Hour-Minute-Format

[Wolfgang Voss]

Hello Newsgroup,
how can I get a number of minutes in a query in hours and minutes (hh:mm) ?

Thank You.

Wolfgang
..

 

[Graham R Seach]

Wolfgang,

Use the Format() function:
SELECT Format(dteMyDate, "hh:nn") As myTime
FROM tblMyTable

....you see, the letter "m" is reserved for Months. To get minutes, you use
the letter "n".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Thomas Winkler]

Hi,

how can I get a number of minutes in a query in hours and minutes (hh:mm)

?

try to calculate the field in your query like this:

HH_MM: minutes \ 60 & ":" & minutes mod 60

HTH

Thomas