1.How could I sort months like Jan, Feb, and March, etc.In the query
it shows Feb, Jan, and March.

2. From another query I need to sum total hours elasped. It is only
showing the time when ended. An expression or how could I format
properly like,
str
11:39:46
end
17:43:16

Total
6:03:30 AM
Prefer it to say 6 hrs and 3 min, use a separate expression or a
format issue?

thanks

format() and DatePart() are what you want I believe.

you can get the months numbers 1 through 12 and the minutes as 6, 3 by
using datediff, format and DatePart.

Should be examples in the help but if you need more holler.

John
jobrien at acscience dot com (figgeritout)

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