sorting by date in reports

[Guest]

I have a report of students who graduate by quarter and year (for example,
03/05, 06/05, 09/05, 12/05, 03/06, 06/06, 09/06, 12/06, etc.) It currently
is sorting by month (for example, 03/05/, 03/06, etc.) I need it to sort by
month and year (03/05, 06/05, 09/05, 12/05, 03/06, 06/06, 09/06, 12/06 etc.)
I read the access help file on dates and it sorts by month. Is there any way
to get it to sort the way the end user wants it by month and year. I have
tried text, number and date data types to no avail. Using Access 2003.

 

[John Spencer (MVP)]

03/05 is NOT a date. A date has a day, month, and year.

Try making the sort criteria
= Right(TheField,2) & Left(TheField,2)

OR adding a calculated column to your query that is that expression and then
using that as the sort criteria in the report. Remember that report sorting is
not controlled by the query, but by the sorting and grouping dialog of the report.

 

[Guest]

Thanks very much-that fixed the problem. I added a calculated columns to all
of my queries and used that in the sorting and grouping dialog.