Field properties

[Steve J]

Hi i have a whole load of records with a field which currently contains a
numeric figure. It is set to long .

The figure represents the number of minutes.

My question is:
1. What is the best field type to change these to, so that I can them sume
the total number of hours with a group

Many thanks
S

 

[Allen Browne]

Long is best.

After summing, you can display the result as hours and fractions of an hour
with
=Sum([Minutes]) / 60

Or, if you prefer to show the hours:minutes format:
=Sum([Minutes]) \ 60 & Format(Sum([Minutes]) Mod 60 "\:00")