Sort order for a Report

[Jim L.]

I have a report that shows account numbers and transactions. I added an
order sequence field to the table to arrange these numbers in the
non-numerical order I want, then sort ascending by that number in the query.
This works out great in the query that the report is sourced from, but the
report still shows the account numbers in numerical order. In the report
properties, the 'Order By' area shows the order sequence field, and 'Order By
On' shows 'Yes', but it isn't working. What am I missing??
Thanks for any help with this!

 

[tina]

suggest you use the Sorting and Grouping dialog (report Design view, from
menu bar choose View | Sorting and Grouping.

hth

 

[Allen Browne]

1. Open the report in design view.

2. Open the Sorting And Grouping pane.

3. Select the field(s) to sort by.

Sorting'n'Grouping has priority over OrderBy.

 

[Jim L.]

Allen,

I didn't know that existed, but it was exactly what I needed. Thanks so much!