Query prompt for table?

[Andrew]

Is it possible to write a query, or perhaps a macro, that
prompts for the table to use? I would like to run the
same query on over 400 tables. This query will get every
table into the same format. Thanks.

Andrew

 

[Ted Allen]

Hi Andrew,

I don't know of a way to prompt for a table, but with 400
tables to do I would think that you would be much better
off working in VB and manipulating the SQL text and
executing the queries there - if there is any way of
defining what you want to do with all of the tables in
code. This wouldn't be very difficult even if you don't
have experience with VB or SQL, if the changes are fairly
uniform or well defined.

Post back with a little more info on what types of
changes you want to make to the tables, and whether they
are consistent, or at least whether they fall into some
general categories that could be detected and handled
appropriately in code. Also, post a sample of the SQL
text from one of the queries (if you are using the query
builder just go to SQL view and copy/paste the text).

-Ted Allen