Sorting lost due to count function (Access 2003)

Topic

New Reply

You cannot rely on the sort order of a table or query in a report. You must specify the sort order for a report in the Sorting and Grouping window (View | Sorting and Grouping).

Reply | Quote

Replies

I have a query with data sorted by address. When I create and run a report based on the query, the data sorts properly. However, if I add the Count() function or a Sum() function to the Report footer, the data no longer sorts. It prints in the table order. What gives?

A sample set of data is attached.

I’ve looked for a solution and can’t find it. Any help you can provide would be great.

Reply | Quote

Thanks for your reply. This confirms what another person told me. I guess I’ll have to rely more on the sorting and grouping capabilities in the report itself.

Reply | Quote