Sort order for a Report


J

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!
 
Ad

Advertisements

T

tina

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

hth
 
A

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

Advertisements

J

Jim L.

Allen,

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

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

Top