Grouping Order

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

Guest

When grouping on a text field, my only choices are ascending or descending
order. Is there any way to make Access group in a particular, customized way
i.e. so you can have the groups listed in a predetermined way rather than
just alphabetically?

Thanks,

Steve
 
You can use expressions in the sorting and grouping levels. You must be able
to either calculate a value to sort or you must store a value. For instance
if you had a column with month name and didn't want to sort them:
April
August
February
...
You could use an expression like:
=Instr("JanFebMarAprMayJunJulAugSepOctNovDec",
Left([MonthNameField],3) )

If you provided more specifics, I expect someone could provide a solution
for you.
 
When grouping on a text field, my only choices are ascending or descending
order. Is there any way to make Access group in a particular, customized way
i.e. so you can have the groups listed in a predetermined way rather than
just alphabetically?

Thanks,

Steve
Click to expand...

Sure.
But without you giving any indication of what the sort should be,
that's the only help I can give you.

Spend some time searching for "custom sort" in www.groups.google and
you'll find plenty of similar questions and an answer.
 
Back
Top