Zip Code Query

G

Guest

I need to create a query for my Access address list by zip codes. For instance, all the address within zip codes 39501 to 39560. I had the query created but inadvertently changed it, saved the wrong formula. Know next to nothing about how to manage Access. Help

S. Ford
 
J

John Spencer (MVP)

Try using a between clause in the criteria

Field: ZipCode
Criteria: Between "39501" and "39560"

Make sure your values are listed in ascending order. Also, I assumed that your
ZipCode field is a text field and NOT a number field. My rule of thumb is if I
am not going to use a "number" to do arithmetic, then it is really a text string
that consists of numeric characters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query on zip codes 2
Zip Code Query 2
Zip Code Query 2
Zip Code Lookup 3
zip code range issue 2
Query with Zip Code Mis-match (5 digit vs 9 digit) 2
Help creating query in Access or should I be using a formula in Ex 3
Query Help 3

Top