How do I create an update query to update fields based on another tabl 2

[SeeWard]

Hi,
I don't know if this can be done in Access, but I would like to be able to update records that contain city and county fields. The proper cities and counties reside in a different table than the main table. Is there a way I can create an update query that would pull the right cities and counties.

 

[SeeWard]

Me again!
I thought I should rephrase the question. How would I go about creating an update query that would update fields in a table based on fields in another table.
I have addresses ...but these addresses contain the wrong counties. I have a table that has all the cities and their corresponding counties. I would like to match the cities and update the counties field. How would I do this please?
Thanks!

 

[PHV]

Something like this ?
UPDATE tblAddresses INNER JOIN tblCounties ON tblAddresses.City = tblCounties.City
SET tblAddresses.County = tblCounties.County

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

If your table of "cities and their corresponding counties" has a primary key of the city, you can create a query with both tables. Join the City fields. Change the query to an update query and update the county with the county from the city/county table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[SeeWard]

Thanks to you both! It works perfectly well and does exactly what I needed it to do!