Sorting Zip Codes

[aguy]

I have a database that has about 650 records (addresses). The zip codes range from 350-- to something like 352-- (some are Zip+4). I need to be able to sort them all into four groups (350, 351, 352, and 35215). Is there a way to build a query to take these zip codes and sort them?

Thanks

 

[Liv Manto]

Ask the clip on how to create and sort a query.

 

[flixx]

To aguy:
Take a look at the Zip1 databse I have attached as a zip file,
look at the 2 query's that are setup as examples. If you have
any questions, just post them.
Hope this helps, Flixx.

 

[aguy]

That works great... Now, is there a way to combine all four queries (for 350, 351, 352, and 35215) into one query and instead of listing the zip codes, count them for me?

Thanks!

EDIT: Also, the Left([Zip Code],3) function doesn't seem to be finding all of the zip codes that meet the criteria... Am I doing something wrong?

 

[aguy]

Okay, I got it counting the zip code prefixes for me. Now, I need it to count all of the 352 prefixes, but exclude all 35215 from its count. Also, can I get Access to count all of the prefixes that are not already counted -- something like tell it to count all zip codes except those that start with 350, 351, and 352?

Thanks