change table name in a query

[jiminy]

I would like to write a program to change the table name in a query, and then run the query. The table structure will not change, nor will the checked fields.
Reason: I always forget the fields (predetermined) I'm looking for.

 

[Miros]

Information on how to dynamically determine the field names is here:

http://www.tek-tips.com/viewthread.cfm?qid=1278707&page=1

Scroll down a bit to jpadie's answers.

I really don't see what making duplicates of your tables will do for you...