Non-alphabetical Group

[EricF]

I have a report that I have grouped based on a certian field. Is it possible to have a non-alphabetical order (A-Z or Z-A)?

[pbaldy]

If you mean you want B-A-C rather than A-B-C or C-B-A, then no (not directly at least). What I've done when I need something like that is to have a table with my A B & C records with an additional field for sort order. Then I can join that table to another in a query which lets me include my custom sort order field, and I sort on that in the report.

[EricF]

Thanks, that was my work around (I used numbers though), but I wanted to see if there was an easier way. Guess not. Thanks

[pbaldy]

No problem (I use numbers for the sort field too).