How to use a combo box to select the table used in a query

[Lisa]

I have a database which holds a seperate table for each
week's financial data. Instead of creating a new query
each week, is it possible to write a query where the
source table is variable and choosen by the user each time
the query is run, say by a combo box on a form? More
efficient ways to perform this wold be appreciated too.
Thanks.

 

[Tom Wickerath]

A more efficient way would be to redesign your database. There is no reason that a
separate table should exist for each week's data. What you are asking is certainly
possible, but it involves VBA code. You will be better served by redesigning this
database. Trust me.

Here are some links for you on database design. Brew a good pot of coffee and enjoy
reading!

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208


Tom
________________________________________


I have a database which holds a seperate table for each
week's financial data. Instead of creating a new query
each week, is it possible to write a query where the
source table is variable and chosen by the user each time
the query is run, say by a combo box on a form? More
efficient ways to perform this would be appreciated too.
Thanks.