Run a query prompting specific table name

[Guest]

Hi,

I want to run a report from a query or straight from a table.

Is it possible to give the report or query criteria for choosing a specific
table?

I add a new table each week and do not want to have to change the current
week's table name to run a query or report.

Thank you.

 

[Guest]

Instead of creating a new table each week, could you have 1 unique table that
you retain, but use delete query to empty table contents, then each week, use
append query to populate the table with new data? That way, your report
always uses same table name.