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