Run query multiple times on different tables

[dumbledown]

Hi,

I have several tables (table_1, table_2......, table_n); I know value n - but this will change from use to use.
I have a query that will produce an output from these tables.

Does anyone know how I can code or refer to the same query so:

table_1 ------QueryA-------output_1
table_2 ------QueryA-------output_2
.
.


table_n ------QueryA-------output_n

Many thanks
Hugh

[Robeen]

You can do this using VBA - but not really using the 'same' query since each one refers to a different table.
Do all the tables have the same fields?
You'd have to pass the VBA Function the value of 'n', and then Loop through each Table number and output number and increment the number at the end of the Loop.

[dumbledown]

Sorry for the slow reply. Thanks, yes I've done what you said, converting the SQL to VBA. It works great.