Sort by Month...

D

Denny G.

In a blank column of your "Totals Query," in the "Field"
row enter "Month: DatePart("m",[Your date field name])"
without the outside quotes. Then sort ascending on this
field/column.

Denny G.
-----Original Message-----
Hi There,

I have a totals query that looks like this:

Month (formatted from Date field in table) Overtime
April 34
16
25


and would like to sort the report by Month so that
Click to expand...
January appears first. Is there a way I can format this?
I have figured out how to format the query so that it
will sort, by creating a Month ID. But can't figure out
how to use that in the report and hide the numbers.
 
Top