Querying Table Name from a Listbox

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

Guest

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.
 
Do not have a table per date - have a datetime field in the table and use
criteria to select the correct data.
 
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.
 
Back
Top