Selecting the table on which to run the query

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

Guest

Hi,

I have 1 master table (lets say Ttoday) and each month make a copy of it
(kind of archive T012006, T022006, etc.).

I have 1 master query (lets say Q01) on the master table and a whole set of
queries running on this Q01.

Right now, the user can only perform (via a switchboard, not getting in the
query itself) queries on the Ttoday table. What I want to do is to make it
possible for the user to select if he wants the queries to run on Ttoday or
on another table (T012006, etc.), if possible via a combo box that would list
the available tables. As all subqueries run from Q01 I guess I only have to
find the solution to, in Q01, point to the selected table, but how? How do I
tell the query that the table to look in is the result of a cobo box choice?
If possible in Designview, i.e. avoiding VB code... ;)

Thanx for the answer,
duxxyy.
 
Hi Lynn,

Thanx for the hint. I had thought about this solution, especially because
there is already a date field in each record telling the 'exctract' date. I
will try it, however the 'main' table is not a table but a link to a table on
which I have no write access. But this should be no problem.

Thanx again.
 
Back
Top