Access report ignores the sort order from my query

Question

Built a query in MS Access sorted by date, but when I make a report from it the rows come out in a different order. Where do you set sorting in the report itself?

asha_37 · Answer

Reports ignore the query's sort, by design. Open the report in design view, Report Design tab > Group & Sort, add a sort on the date field in the pane at the bottom. That wins over the query.

Access report ignores the sort order from my query

Leave A Reply

1 Answer