If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Urgent!!! Zip code Look Up
I have 2 tables. Table1 has Zip Codes from many cities, also table1 has
a field(yes/no) that says "houston". Table2 has zip codes from houston city. I want to be able tu run table2 against table1 to compare zipcodes and if table1 has a zipcode that match table2, i want to update the field(yes/no). Any macros or queries??? Thank you |
#2
|
|||
|
|||
Urgent!!! Zip code Look Up
UPDATE Table1
SET Houston = True WHERE Table1.ZIP in (SELECT Table2.Zip FROM Table2) OR UPDATE TABLE1 INNER JOIN Table2 On Table1.Zip = Table2.Zip SET Houston = True "robpiolink" wrote in message oups.com... I have 2 tables. Table1 has Zip Codes from many cities, also table1 has a field(yes/no) that says "houston". Table2 has zip codes from houston city. I want to be able tu run table2 against table1 to compare zipcodes and if table1 has a zipcode that match table2, i want to update the field(yes/no). Any macros or queries??? Thank you |
Thread Tools | |
Display Modes | |
|
|