Sort special

Topic

New Reply

Hello, I have a question about sorting.

My table has special sorting. I have created translation table where
1USA
2Canada
3Asia

Actual Report has Country and City Groups.
When placed in Report – data comes out sorted ascending.

How can I get that special sort? Thanks

Reply | Quote

Replies

Sort descending?

Reply | Quote

Create a query based on your table and on the translation table, joined on the appropriate field.
Use this query as record source for the report.
In the Sorting and Grouping window, specify the number field instead of the Country field for the first sorting/grouping level.

Reply | Quote

Thanks, Hans, I did it and it works.

Reply | Quote