Tables Joining Question from Newbie

  • Thread starter Thread starter ugogirl65
  • Start date Start date
U

ugogirl65

New to access and limited db experience and I can't seem to get my brain
wrapped around this. I have two tables the first is a contact table
containing address info .ie city, state, zip. The second table contains
zone info. The fist field is the first three digits of the zip code
then the zone for that zip code. How do I link this info back to the
contact table so that the infomation in zone table can be displayed on
contact form? Would this be done with a query?



Thank you for any help at all.
 
I'm not sure I understand the need for the second table. If the zone you
refer to is always the 4th and 5th digits of the zip code then you can
extract in a query the 2 parts like this:

Select Left([ZipCode],3) AS FirstThree, Mid([ZipCode],3,2) AS Zone
From YourTable;
 
I'm sorry looks like I was unclear in the first post. I have two tables



Conttble

ContID (PK)

Address

City

State

Zip



And a second table which is all ready filled in with Zip codes from
around the country and their zones.

Zonetbl

Zip (First three digits of US zip codes

Zone (for my area.)



This was set up so that we would know what zone a package would be sent
to if say it was sent to 90210 from here. The chart given by the post
office says zone 9, but I want this info to picked up from the second
table Zonetbl.



Hope this is more clear someone can help me. Please.



Hope this is more clear.
 
Back
Top