report page date

[nashr1928]

I have a report that has 332 pages that reflect a main form that has 332 records. I open the report and the pages do not show in order by latest date of latest record. I changed the table and the query to sort ascending but the report looks the same. What am I doing wrong?

[PrintShopSup]

If I read your question correctly, you are trying to get the most recent date first. I believe that the query sort would be decending instead of ascending...

[pbaldy]

For a report, you need to set up the sort you want in View/Sorting and Grouping.

[nashr1928]

I went ahead and sorted the date fields in the report. This worked fine. Before I had mistakenly selected the wrong field. Your suggestion works perfect. Thank you for your assistance.