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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Sorting on the value of a text box in each record? 2
Sorting unrelated controls on a report 17
Coordinating the sort order in a report with the underlying query 2
Sort of Concatenated Field 1
ACC: How to Sort Concatenated List of Items from a Many-Side Table 0
Sorting in Query and Report involving look up combo box 1
Unable To Use Group & Sort Options 2

Top