Query From Different table EVERYTIME

[N1ck9141]

I have Multiple Table all in the same Format...
I Can create a query to select all the data which has "Name" in Collum1..

But i Dont want to have to recreate this query for all 700 Tables..

So can i create a query that ask for Table Name or Source Table before running???

 

[namliam]

I have Multiple Table all in the same Format...
I Can create a query to select all the data which has "Name" in Collum1..

But i Dont want to have to recreate this query for all 700 Tables..

So can i create a query that ask for Table Name or Source Table before running???

Wow 700 tables with the same format, same data??? EEK

No you cannot do this... If you want something like this you have to write coding that will build the sql for you...