How to order report by date?

[tom]

I have a report based on a very complicated set of queries. I have
everything working as I want except I
want the report ordered by date within each grouping.

I have tried to change the queries to order by date but
that didn't work. The whole report is based on a very
complicated union query. I do not really want to edit
this query if possible since that would take alot of time
and effort.

Any ideas on how to get the report to order by date?

 

[Wayne-I-M]

Add the date to the report and use the shorting and grouping option (select
the date and choose asending or desending)

Good luck

 

[fredg]

I have a report based on a very complicated set of queries. I have
everything working as I want except I
want the report ordered by date within each grouping.

I have tried to change the queries to order by date but
that didn't work. The whole report is based on a very
complicated union query. I do not really want to edit
this query if possible since that would take alot of time
and effort.

Any ideas on how to get the report to order by date?

Any sort order in your query is irrelevant in the report.
To properly sort the report you must use the Report's Sorting and
Grouping dialog.