Run same type of query on multiple tables

[jojo]

Is there a simple way (perhaps with a macro) to run the same type of query on
multiple tables. I have 15 different tables (all with the same structure)
and need to run the same type of query on each. I want to know if there was
a simplier way instead of creating 15 different queries. I was thinking
maybe passing a parameter within sql but I'm not sure how to do that.

 

[tina]

what do you mean by "same structure"? same number of fields? same fields
names? same data types in each field? and can you write the query you want,
on just *one* table, and then post the SQL so we can look at it?

btw, if these 15 tables actually are *identical*, can you tell us why you
have 15 identical tables in your database?