concatenated field in a report is not sorted



My report uses a query which concatenates 2 fields:

concatenatedField: [field1] & " (" & [field2] & ")"
sort: Ascending

(the query contains other fields without sorting)

When I run the query the concatenated field is sorted correctly but in a
report, which uses the query, sorting is incorrect (or there is no sorting).

I appreciate any suggestion why this happens.

Access 2003
Win Vista

Douglas J. Steele

Reports don't respect the order of records in queries being used as the
recordsource of the report. You must use the report's Sorting and Grouping

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