Run Same Query Against Different Tables

[Marsellus]

I have a bunch of queries that I've built that will remain the same, as far as the formulas go. However, I need to be able to run the query against a different table every day (a different set of data). How do I make this process as automated as possible? I try to type the new table into the "Table:" row in the query design but since the table isn't listed in the list it won't accept.
Any suggestions?
Thanks!

 

[RobCPA]

This is something that I sometimes do: Either copy or rename the new daily table to a name that the query was originally based on.

So, for example, if the query was based on "tblTable", and the daily table is called "tblTodaysData", then you could copy the "tblTodaysData" to "tblTable", or rename it as such. Your query will work fine as long as all of the underlying fields remain the same.

This trick will eliminate the need to create different queries for different day's data.