Hi,

I have a table containing a date/time field.  I have a summary query based
on this table which was set up using the wizard.  I stipulated to group by
month when asked. (i.e. All records in April 2005)

The query works fine.  However when I try and sort on the month field it
sorts based on the letter beginning the month i.e.

April 2005
February 2005
June 2005
May 2005

I want to output the query results in a report, which I will need in
ascending date order, not Date alpha order.

I don't know why it does this as the original date field is definitely a
date type & format etc.

Any help would be greatly appreciated.

-Jay-