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.
 

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

Sort of Concatenated Field 1
Sorting on the value of a text box in each record? 2
Field sorting problem 2
Coordinating the sort order in a report with the underlying query 2
Sorting according to field chosen after report previewed 2
Sort not working correctly 6
Sorting text field value in a report 4
Format part of a concatenated control 1

Back
Top