Solved Inconsistent sort (1 Viewer)

[PaquettePaul]

I have a report based on a query which provides financial activity for a person. In the query, the data is sorted by student, effective date, and financial type. When I look at the results of the query, the student and date information are correct as well as the financial activity - goods and services (type 21) is followed by goods and services tax (type 22) which is followed by a debit payment (type 30). However, in the report, the debit payment is listed before the other two entries. Note that internally, the primary key of the records is payments before charges.

Not much sense showing you any code as the query is correct and there is nothing in the code to change the sort. The only processing that occurs is the data is filtered for a specific student as part of the report filter criteria.

Any suggestions to resolve this inconsistency?

 

[June7]

Query sort is generally ignored by report. Use report design (Sorting & Grouping) to specify sort order.

 

[The_Doc_Man]

Just to confirm June7's suggestion, Access will not honor the sort inherent in your recordsource query. The report writer wants to retain full control because of the way it wants to insert headers and footers. You have to use the report builder's sort and header/footer options.

 

[Gasman]

Query sort is generally ignored by report. Use report design (Sorting & Grouping) to specify sort order.

Unless you ask it nicely?

 

[PaquettePaul]

Yup, that did the trick.