Querying Table Name from a Listbox

A

anon

Is there any way to use what is picked in a listbox as the table name in a
query? Say I have a table that contains all my data which changes from week
to week. I want the user to be able to pick the date (which is the same as
the table name) and run a query to compare it to the current week (I've
created linked tables to archived versions of the database). Access doesn't
seem to accept a list box value as a Table name in the query. Let me know if
there's anyone knows a way around this.
 
K

KARL DEWEY

Do not have a table per date - have a datetime field in the table and use
criteria to select the correct data.
 
A

anon

That would involve combining all the data into one table wouldn't it? In my
case that would get prohibitively large (well over a million records). The
data changes from week to week, there are additions, deletions, and of course
updates. I import new data every week and overwrite the old 'main table'. I
know having a table per date isn't the best way to do things, but I really
don't have too much of a choice at this point. I'd really like for the query
to read the table that's picked in the form and run a query against that
specific table. If it isn't possible just let me know.
 
Top