Criteria sorting zip codes

[retired fire]

I have a large data base that is used to print mailing labels...

I need to sort the zip codes in a specific order (not accending and not
decending).

Example: zip code order might be 23101, 19234,43688, 30245, 71403, 28409

The zip codes need to be in specific order.

Hope there is a way to do this....

Any help is appreciated.........

 

[Ken Snell \(MVP\)]

Add a field to the zip codes table -- name it SortValue. Then put integer
numbers in that field that will identify how the codes are to be sorted,
then sort on that field in your queries that give you the zip codes. This
assumes that there will always be just a single sort order for the zip
codes; if there will be multiple ones, then you'll need to use a temporary
table that will hold zip codes and a sorting field, and you'll need to
insert the desired sort order in the sorting field.