sorting and formatting sum of hours

#1

Need to sort months like jan, feb and march. My results shows feb,jan,
and march using a query. please advise.

What expression or how should I format total sum in hours? I keep
getting the elasped time, need it to show something like 7 hours not
23:15:00 pm. This will be quering another query. pleas advis..

thanks.

#2

DateDiff()

John
jobrien at acscience dot com

work111698 (AT) comcast (DOT) net (neo) wrote in message news:<53509ba4.0311050423.49e3d515 (AT) posting (DOT) google.com>...

Quote:

Need to sort months like jan, feb and march. My results shows feb,jan,
and march using a query. please advise.

What expression or how should I format total sum in hours? I keep
getting the elasped time, need it to show something like 7 hours not
23:15:00 pm. This will be quering another query. pleas advis..

thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sorting and formatting sum of hours

comp.database.ms-access comp.database.ms-access

sorting and formatting sum of hours - 11-05-2003 , 06:23 AM

Re: sorting and formatting sum of hours - 11-05-2003 , 09:23 PM