Update Lat / Lon values with data from another table

[fernipascual]

Hello community:



This is my first thread here. Extremely novice MS Access user. Thank you in advance for your patience.

I have a 'Zip_Code_Lat_Lon' table with City, State, Zip, Lat, Lon and I want to update a 'Customer Details List' table with the latitude and longitude. The fields are blank in 'Customer Details List' . I need a query that looks at the zip code listed in 'Customer Details List' , finds the value for lat and lon in 'Zip_Code_Lat_Lon' and updates my 'Customer Details List' table.

Note: I download form entries from seven forms on my wordpress site. They contain similar information (name, address, city, state, zip; certain brand preferences and usage rates). I imported each form's raw data as separate tables into MS Access so I can reduce the time it takes me to filter in Excel using multiple criteria. Data redundancy is not something I'm looking to solve right now as I have competing priorities. I'm exploring a potential solution within wordpress so in the meantime Access needs to be my friend.

Thanks again!

[alansidman]

If I am understanding correctly, you want to create a query that joins your two tables on the Zip Code Fields, adding in the fields you require.

https://support.office.com/en-us/art...1-07061a1478f6

[fernipascual]

Thanks so much! I did it correctly on the first try!