
January 14th, 2004, 02:50 AM
|
|
Registered User
|
|
Join Date: Dec 2003
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Challenging Query to Me. Soluctions?
I have serveral tables DAUD2004, DAUD2003, DAUD2002 and so on in MS ACCESS which has exactly the same fields.
Is there a way to construct a query which allows user to key in a parameter so as to select the table to query?
For example,
User will be prompt to enter the year eg..2002
Then the query like this will start to run
SELECT a, b, c
FROM DAUD**** (**** represents the variable year)
WHERE x='bb';
Thanks
|