Zip Code Query

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top