sort order

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

I have the following groupings on my report : Local, Export and Stock . The
report always lists them alphabetically but I want them to be listed in the
order I have listed above . How do I do this?

GK
 
I would create a table (or add a field to an existing table) that stores the
sorting order. You can then include the SortingOrder field in your report's
record source.

If you don't want to maintain the data, try set your sorting and grouping
expression to:
=Instr("LocalExportStock", [YourField])
 
Back
Top