Minutes to Hours and Minutes

L

Lindsey M

Hi everyone

I have a tables that includes the fields Mins. I'm using this in a crosstab
query but I want it show the minutes in Hours and Minutes. I wrote a function
that would convert them but this doesn't work in the Crosstab because the it
won't Sum them (if that makes sense).

Any ideas?

Cheers
Lindsey
 
A

Allen Browne

Probably easiest to make another object to display the result, such as a
form in datasheet view (or even another query if you must.)

Assuming a field named Minutes, you would set the Control Source of your
text box to:
=[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")
 
Top