Run a query prompting specific table name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 15 Aug 2006 16:22 GMT

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.

Reply to this Message

Chris - 15 Aug 2006 16:29 GMT

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.

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message