sort order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gregork - 28 Feb 2005 07:04 GMT

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

Reply to this Message

Duane Hookom - 28 Feb 2005 15:41 GMT

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])

Signature

Duane Hookom
MS Access MVP
--

>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

Reply to this Message