Report not printing in correct sort order

[MarkGardner]

I have a report pointing to a query using a "stmtcode" field name to sort by in the Record Source and it prints correctly, BUT when I try to change to a different sort using "mailcode" field name, it still gives me same sort as before.

For that second report I am using a query with a variation of the original report but uses a different query in the Record Source of the Property Sheet that sorts by "mailcode". It still gives me the original sort.

I look at the query that the second report is pointing to in datasheet view and I see the data listed in exactly the order that I want, but when I open the report in report view, it gives me the sort by "stmtcode" and not "mailcode". I think that somewhere the report it is still pointing to the original sort using "stmtcode" and not "mailcode" and I do not know where else to look.

Any help that I get will be appreciated.

By the way I do not do SQL nor VBA and I am sure that it is something simple in the properties that I am missing.

 

[boblarson]

For reports you need to go into VIEW > Sorting and Grouping and set the sort order there. Reports don't usually keep the sorting in the queries, so you need to set the order you want in the report.

 

[MarkGardner]

Thank you very much! I had forgotten about that feature. I knew it was something simple and you were a great help to me. I was trying to do it by using a query so that I could use the exact same report so that if I ever had to change the layout, I would only have to do it in one report and not in both. I can deal with that problem.
Thanks again.
Mark