Zip Code Lookup

[saum]

I want to create a query or table which contains a range of three digit zip codes per person or company: ie. 930 - 990, Joe Smith or ABC Company.

Zip code from a contact query or table would indicate Joe Smith or ABC Company.

I know it is possible by using a VLOOKUP in XLS, but would rather try it in ACCESS.

Thanks for any assistance.

Steve

 

[Maquis]

Try DLookup.

In one of my databases, I have a Zip Code table which contains all the zip codes in the United States (updated regularly) with their corresponding cities and states.

When a user types a zip code into my customer form, I have a DLookup automatically populate my city and state fields from the table.
Maq
<insert witty signature here>