Update query to update more than one table?

[Guest]

Is it possible to use an update query to change data on different tables

Here's what I have

the following tables
IndustrialPropertie
OfficePropertie
LandPropertie
Retail Propertie
InvestmentPropertie

each table has the following field
Cit
Stat
Zi

CSZ
the CSZ has the following cod
[City] & ", " & [State] & " " & [Zip

Unfortunately, this won't work, even though the tables are separate in the query

Do I need to create an update query for each property type table

Thanks,
Emily V

 

[John Vinson]

Do I need to create an update query for each property type table?

Yes but... The field CSZ *should not exist in your table*. It's
redundant. Just calculate it in a Query whenever you need it.