How do I sort items in the order I want, not alphabetically.

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

Guest

I am doing a report that requires the following five sections to be in this
exact order:

Claims, Prelitigation, Litigation, Arbitrations, PERBS.

How can I keep my data to sort under those Five matters in that order?
Access seems to default only to alphabetical or numerical. I want to choose
the way I want it sorted, not have it sorted by Arbitration, Claims,
Litigation, PERBs, Prelitigation.
 
Look at View | Sorting & Grouping menu in report's design view. You set the
sort order there.
 
The problem is that the five different areas are not in individual cells, but
one cell called matter type. So I don't think that will work.
 
Huh?

Please explain your report's RecordSource query's structure. I don't
understand what you mean (note: there are no "cells" in ACCESS).
 
I should have said the field is the Matter Type with a drop down from a table
of different parts of litigation (claims, lit, prelit, etc.).

I only can find the traditional sorting by ascending or descending for the
sorting/grouping. Basically I want to ask it to sort by the way I want it and
not just ascending or descending. Make sense? I'm new at this (obviously).
 
I would add a new numeric field to your Litigation types lookup table
called SortOrder and populate this with numbers in the order that you
want. Add this field in to the recordsource of your report, presumably
a query, and base your sort within the report on this field. Then you
are in control of the sort order.
 
Back
Top