Sorting for report presentation - can I set a specific order?

V

Vector

I have a report which will group items by product category. I am currently
sorting by category however I do not want to sort alphabetically .... rather,
I want to specify the order in which each category appears in the report.

There are some categories which I want to appear at the very end of the
report, and doing an alpha sort would actually stick them in the middle pages.

How can I get around this problem?
 
A

Allen Browne

Open your Category table in design view, and add a Number field. By
numbering the records, you teach Access the sort order you want. Include
this field in the report's RecordSource query, and you can now sort the
report by this field (in the report's Sortin'n'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

Group Items on Report but do Not Sort the Group alphabetically 2
Preferred way to do sort order - column in table, or specified in query? 3
Report sorting 1
Trouble with my sorting and grouping 4
My report is not alphabetizing during the sort. 3
Do I need different reports to change Sort Order? 2
ACC: How to Sort Concatenated List of Items from a Many-Side Table 0
Sorting report by grand total from report footer 2

Top