Request for help

[Brent White]

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.

['69 Camaro]

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.

[storrboy]

On Mar 8, 4:14 pm, "Brent White" <[e-mail]:

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?

[AlterEgo]

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.

[salad]

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.

[Phil Wyatt]

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.