sort by date

[Fie]

Hi,

I have date in a report grouped by month, only problem is when I order
the month is displays it in alphabetical order instead or the actual
month order. How do I do this? Also I want to order the months
starting from April 2006 proceeding to Feb 2007.

Fiona

 

[Douglas J. Steele]

Assuming you have a date field in your table, create a query that has a
computed field using Format([MyDateField], "yyyymm") and sort on that field.