concatenated field in a report is not sorted

J

jaworski_m

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
 
D

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
dialog.
 

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

Sorting on the value of a text box in each record? 2
Coordinating the sort order in a report with the underlying query 2
Access MSACCESS - Sorting report based on field calculated in the report 0
Sorting in Query and Report involving look up combo box 15
Sorting according to field chosen after report previewed 2
Sorting by one field, Grouping by another? 1
Sort Not Working 3
Unable To Use Group & Sort Options 2

Top