By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,039 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,039 IT Pros & Developers. It's quick & easy.

Request for help

P: n/a
I'm wondering how deep this might go. You know how if you say
"Raleigh, NC" you get all the ZIP codes that are explicitly Raleigh,
NC? Well, is there a database where you could say "Raleigh, NC" and
get the ZIP codes for not just Raleigh, but, for example, Wake Forest,
Cary, Apex, Morrisville, Garner, etc?

This would be stored in either Access 2000 database or in a Microsoft
SQL Server table, though preferably the former.

Mar 8 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi, Brent.
is there a database where you could say "Raleigh, NC" and
get the ZIP codes for not just Raleigh, but, for example, Wake Forest,
Cary, Apex, Morrisville, Garner, etc?
I doubt there are any free ones. Feel free to build one yourself from one
of the free ones by adding an additional column for "nearest major city" and
populating it manually with the appropriate Zip Code. Then your queries
would need to be designed to return the values of the Zip Codes where the
nearest major city's Zip Code matched the one assigned to the user's input
for the city and state.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Brent White" <bw****@badgersportswear.comwrote in message
news:11**********************@s48g2000cws.googlegr oups.com...
I'm wondering how deep this might go. You know how if you say
"Raleigh, NC" you get all the ZIP codes that are explicitly Raleigh,
NC? Well, is there a database where you could say "Raleigh, NC" and
get the ZIP codes for not just Raleigh, but, for example, Wake Forest,
Cary, Apex, Morrisville, Garner, etc?

This would be stored in either Access 2000 database or in a Microsoft
SQL Server table, though preferably the former.

Mar 8 '07 #2

P: n/a
On Mar 8, 4:14 pm, "Brent White" <bwh...@badgersportswear.comwrote:
I'm wondering how deep this might go. You know how if you say
"Raleigh, NC" you get all the ZIP codes that are explicitly Raleigh,
NC? Well, is there a database where you could say "Raleigh, NC" and
get the ZIP codes for not just Raleigh, but, for example, Wake Forest,
Cary, Apex, Morrisville, Garner, etc?

This would be stored in either Access 2000 database or in a Microsoft
SQL Server table, though preferably the former.

Does the US post office supply such info or service?

Mar 8 '07 #3

P: n/a
Brent,

What you are probably looking for is the relationship between MSA
(Metropolitan Statistical Area) and Zip Code. Try starting at the US Census
site: www.census.gov

-- Bill

"Brent White" <bw****@badgersportswear.comwrote in message
news:11**********************@s48g2000cws.googlegr oups.com...
I'm wondering how deep this might go. You know how if you say
"Raleigh, NC" you get all the ZIP codes that are explicitly Raleigh,
NC? Well, is there a database where you could say "Raleigh, NC" and
get the ZIP codes for not just Raleigh, but, for example, Wake Forest,
Cary, Apex, Morrisville, Garner, etc?

This would be stored in either Access 2000 database or in a Microsoft
SQL Server table, though preferably the former.

Mar 9 '07 #4

P: n/a
Brent White wrote:
I'm wondering how deep this might go. You know how if you say
"Raleigh, NC" you get all the ZIP codes that are explicitly Raleigh,
NC? Well, is there a database where you could say "Raleigh, NC" and
get the ZIP codes for not just Raleigh, but, for example, Wake Forest,
Cary, Apex, Morrisville, Garner, etc?

This would be stored in either Access 2000 database or in a Microsoft
SQL Server table, though preferably the former.
What happens if you select Wake Forrest? You need the links to all the
others. Maybe by using longitude/latitude numbers you can calc
distances and those in a defined radious displays the zips.

Storrboy is correct, you should ask the Post Office.

The technology is there. You get on a web, goto a store, and enter a
zip code to locate the nearest stores. You get back a list of all
stores in a certain mile range.
Mar 9 '07 #5

P: n/a
You can certainly get "similar" types of information in australia.

http://www1.auspost.com.au/postcodes/index.asp?sub=2

may not be perfect but would get you part way down the track to the solution
you are seeking.
"Brent White" <bw****@badgersportswear.comwrote in message
news:11**********************@s48g2000cws.googlegr oups.com...
I'm wondering how deep this might go. You know how if you say
"Raleigh, NC" you get all the ZIP codes that are explicitly Raleigh,
NC? Well, is there a database where you could say "Raleigh, NC" and
get the ZIP codes for not just Raleigh, but, for example, Wake Forest,
Cary, Apex, Morrisville, Garner, etc?

This would be stored in either Access 2000 database or in a Microsoft
SQL Server table, though preferably the former.

Mar 9 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.