Update Query using same criteria for multiple Tables

[Manuel Indacochea via AccessMonster.com]

I have at list 10 different tables and all of them include a field named
"PlantCode" (among others). I made an update query using several criteria,
one of them is(for example)

UPDATE TO "New"
CRITERIA "Null"

This worked fine if only Table1 is referenced, but, Can I make one single
Update Query work with all 10 tables at the sametime? I mean, I want to
update all 10 tables in one step since the criteria will be the same for
all of them.

Thanks in advance for your help.

 

[John Vinson]

This worked fine if only Table1 is referenced, but, Can I make one single
Update Query work with all 10 tables at the sametime?

You can't. The table name is obligatory. You can store ten update
queries and run them from a Macro or (better) from code, or you can
build the SQL in code and execute it, but you need ten queries one way
or another.

Why do you have ten tables with the same data?? Something isn't
properly normalized here, I fear!

John W. Vinson[MVP]

 

[Manuel Indacochea via AccessMonster.com]

Thanks for your comments. I beleive that I will try to do that through a
Macro. Besides, they are not ten tables with the same data, all of them
have different information which have in common only the Plants field.

Again, thanks so much for your time and advice.