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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.)
 
Back
Top