sorting grouped records in descending order

[ianking]

I have a query which sorts the date field in a record in descencing order, yet when I create a report which groups these records by date the groups are always in ascending order even if I select ascending (by day, year or month etc) in the report wizard. Anyone know what is going wrong?

 

[JANR]

I belive Reports ignore sorting in queries, you must use the reports own sorting.

JR

 

[ianking]

I belive Reports ignore sorting in queries, you must use the reports own sorting.

JR

Not only do they ignore sorting in queries, but they appear in this case to ignore the report's own sorting. Its always gouped in ascending order not descending, no matter what I select.

 

[gjarvie]

These reports were being created using Access 2003 - if that makes any difference.