querry and report grouping none alphabetical

[newtoAccess]

Is there a way to do a sort order that is not alphabetical, but is predefined order?


I have a list of Groups that I want in a report in a specific order that is not Alphabetical.
How do I do it?

[pbaldy]

I'd have a sort field in my "Groups" table. When you join that table to other tables in a query, you can include the sort field to get the sort order you desire.

[newtoAccess]

I did something like that.

Thanks

[pbaldy]

No problemo.

[newtoAccess]

Thanks

It worked