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