MarkGardner
Registered User.
- Local time
- Today, 08:43
- Joined
- Mar 27, 2008
- Messages
- 43
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.
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.