How do I update to multiple tables?

[gb4u]

I have six separate tables with no relationship, but I need to run the same 4
Update Queries on all six. Is there a way for me to update all six tables at
once, or would I have to run the query 24 times?

Thanks!!

 

[John W. Vinson]

I have six separate tables with no relationship, but I need to run the same 4
Update Queries on all six. Is there a way for me to update all six tables at
once, or would I have to run the query 24 times?

Thanks!!

You'll need to run each query six times, as you describe it. If this is a
recurrent task you can set up a Macro or some VBA code to run the 24 queries.

The fact that you have six apparently similarly structured tables is probably
a major design problem for starters. It may or may not be possible to
consolidate the four update queries into one, depending on what they're
intended to update.