How do I sort a query to show by month rather than by year

Z

Zappamat

I have the date field set up for long dates but when I run queries it sorts
by year then month. I don't care about the year I just want to report on
months.
 
A

Allen Browne

Type this into a fresh column of the query design grid, in the Field row:
Month([MyDate])
substituting your the name of your date field for MyDate.

Choose Ascending in the Sorting row under this field, instead of your date
field.

The query will not sort only by the month of the date.

If you wish to sort by the day as well as the month, enter the next column
like this:
Day([MyDate])
 
Top