Zip Code Lookup

[jrcigar]

I am trying to look up a territory for a given zip code. Can someone please
help?

I have one table with a list of about 10,000 stores including their
zipcodes. I have another table with about 3,000 zip codes and their
corresponding territories. I'd like to return the territory that corresponds
to each of the store's zip codes.

Thanks!

 

[tina]

make sure the data type of the zip code fields in the two tables match -
both Number, or both Text.

open a query in Design view. add tblStores, then add tblZipCodes. in
tblStores, click on the ZipCode field and drag a link to the ZipCode field
in tblZipCodes. make it a LEFT JOIN; that is, "show all records in
tblStores, and and only matching records in tblZipCodes".

drag the fields from each table, that you want in the query output, into the
query grid.

hth

 

[jrcigar]

Thanks, tina! That worked!

make sure the data type of the zip code fields in the two tables match -
both Number, or both Text.

open a query in Design view. add tblStores, then add tblZipCodes. in
tblStores, click on the ZipCode field and drag a link to the ZipCode field
in tblZipCodes. make it a LEFT JOIN; that is, "show all records in
tblStores, and and only matching records in tblZipCodes".

drag the fields from each table, that you want in the query output, into the
query grid.

hth

 

[tina]

you're welcome

Thanks, tina! That worked!