Custom sort order (1 Viewer)

M

marksac

Guest
Is there a way to do a sorting of data in certain way? For example in Excel I can sort data using Custom Sort order. I need to sort some data by Zip Code but the zip codes need to be in a specific order.
Thanx
 

raskew

AWF VIP
Local time
Today, 07:38
Joined
Jun 2, 2001
Messages
2,734
Access doesn't have a Custom Sort function, but if your sort requirements are logical, it's probably doable with VBA. Please describe your requirement.
 
M

marksac

Guest
Hi,
thanx for the reply.
No the sort order is not really in any logical order, it is simply a mixture of Zip codes.
For example:
95670,95824,95826,95820 etc.
 

cfmiles

Registered User.
Local time
Today, 12:38
Joined
Jul 9, 2001
Messages
17
You COULD create another table with the Zip Codes as one field and the Sort Order as another field (1, 2, 3) then attach the table to your Query and use the Sort Order field to sort on.

I'm sure there are other ways - but this may be the simplest - especially with a large number of Zip Codes. Easy to maintain if you want to change the sort order.
 

Users who are viewing this thread

Top Bottom