Update query to update more than one table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Do I need to create an update query for each property type table?
Click to expand...

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