Run same type of query on multiple tables

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

Guest

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.
 
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?
 
Back
Top