Summary Query - grouping by Month

[Jay]

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-

 

[KARL DEWEY]

Just answered in another group --

Open the query in design view and insert a column to the left of your present
Month-Year column. Use Format([YourDateField],"yyyymm") and uncheck the box
for display. It will be sorted correctly.