How to query multiple zip codes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of over 380k records that I need to separate out by zip
codes. What I am doing is getting a 50 mile radius of my directors across
the country and this program comes up with a list of zip codes in that
radius. Just for OR, I have 7 pages of zip codes (182 zips). Is there an
easy way in Access to get only those zips? Some I can use the operator
between "97005-97024", but I can't do the entire list that way. I've always
wanted to figure this out. Thanks for any help to make this easier for me.
I have about 48 regions to do.
 
You might check out Microsoft MapPoint especially if this is something that
you will be doing often.
 
You might try IN("97005", "97008", "97015", "97023")
But, I don't know if there is a limit to either the number of items in the
list or the length of the SQL statement. I know there is a limit to the
lenght of an SQL statment, but I don't remember what it is.
 
Hi Jerry:

I do have Mappoint. Can I import my Access file and get the results I need
by entering in a zip code and asking for all records that are in a 50 mile
radius? If so that would be great.
 
Yeah, that's my problem, I have over 180 zips to pull around Portland OR.
Are there statements one can write that can pull a 50 mile radius around a
city field?
 
Now you are talking some serious coding. I doubt you have the data necessary
to do this. To be honest, I would not be sure how to tackle this. I am sure
there are commercial packages available that will do that for your.
This is a bit of a far reach, but in the mid 90's I worked for ODOT in
Salem. I was in the group that was responsible for roads and bridges. They
did this sort of thing. I can't remember if it was his first name or his
last, but there was an expert there by the name of Marcus. If you could
track him down, he would know.
 
I don't know enough about MapPoint to help; however, there is a MapPoint
Discussion Group a little lower on the list and it does discuss using it with
Access.
 
Hey Susan ,
Try an rd or remote desktop connection to a pc near u by using a VPN
connection , it will help u if u sync the Computer or lap top to the
Computer which u have or what u can do is use a GPS communicator where in u
can store all , or there is 1 more way where in u create a seprate database
, and just affix the number like
www.areacodes.com
Cya
Sarathy
 
Back
Top