How to display records in ascending order on a report

Q

questy

Hi I have a report that dsiplays query records. I am running this query in
ascending order of a Field. But the report is not dsplayed in the same order
as query. Any suggestions on how I can correct this ?
 
A

Allen Browne

Open the report in design view.

Use the Sorting And Grouping box to define which fields you wish to sort by.

As you found, the sort order for the report is not necessarily the same as
the sort order for its source query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Report Group Footer DLookUp 0
Print order of TriFold - Publisher 365 0
Order records in a report 1
How to automate update on weekly reports spreadsheet 0
Sorting unrelated controls on a report 17
sort order in report detail section 2

Top