update query using a lookup table

[slimjen]

All, using access 2003. I have a table that has city, state and zip field. I also have a table of zipcodes with zip city and state. How can i use an update query to update the city and state fields if I only have the zipcode field filled in?
Thanks

[Robeen]

It IS possible to use the information you have to perform the Update but . . .

Do you really need to have two different tables with BOTH of them having the CIty, State & Zip data in them?
That causes you to have redundancy in your database - by storing duplicate data in different tables.

What you COULD do is use queries that pull in the missing data from the City-State_Zip table.

Is that something you might be able to do - even with your current setup?

[slimjen]

I have a zipcode table that I use for zipcode lookup for the current zipcodes and it happens to have the city and states. The other table i use for storing the data that I need. I did get it to work by using the update query. I had dlookup on the brain. Thanks