G
Guest
I apologize if this type of question has been posted before, but I had
difficulty finding it in the threads.
My database has a tblAddr in which county information is stored using
CountyID using a lookup from tblAddrCounty. I would like to update this table
using a table I generated that includes counties by zip codes (zip is also a
category in tblAddr). My questions are:
1. How do I ensure that zip codes with "0" at the beginning do not show up
as 4 digits when I import this table (the data type for zip in tblAddr is
text)?
2. How can I populate the countyID field in the table I created with the
correct ID based on the county? I tried to set up a lookup from
tblAddrCounty, but this did not work.
3. How should I set up the update query to update records in tblAddr with a
blank for countyID and a zip corresponding to the correct county? I am more
familiar with design than SQL view.
difficulty finding it in the threads.
My database has a tblAddr in which county information is stored using
CountyID using a lookup from tblAddrCounty. I would like to update this table
using a table I generated that includes counties by zip codes (zip is also a
category in tblAddr). My questions are:
1. How do I ensure that zip codes with "0" at the beginning do not show up
as 4 digits when I import this table (the data type for zip in tblAddr is
text)?
2. How can I populate the countyID field in the table I created with the
correct ID based on the county? I tried to set up a lookup from
tblAddrCounty, but this did not work.
3. How should I set up the update query to update records in tblAddr with a
blank for countyID and a zip corresponding to the correct county? I am more
familiar with design than SQL view.