Minutes to Hours and Minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running sum for hour and minute 1
Make-table query with around 2 ml records taking too long 0
Access Convert a decimal time to hours and minutes 2
Converting a number into Hours and Minutes 3
Trying to convert a short time field from hours to minutes 14
Calculation - integer to hours & minutes 5
About hours and minutes 3
Elapsed Time Hours and Minutes 3

Back
Top