concatenated field in a report is not sorted

  • Thread starter Thread starter jaworski_m
  • Start date Start date
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
 
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.
 
Back
Top