How to query multiple zip codes

[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.

 

[Guest]

You might check out Microsoft MapPoint especially if this is something that
you will be doing often.

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

I'm going to have to figure out an easier way. Thanks for your feedback.

 

[Sarathy Arcot]

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