Creating A Query to run from user definable Tables

[hicmoo]

I am using Access 2003 and I have 30 tables that hold the same information for 30 different clients. I generate annual reports for each client. I am wanting to set up a make table query that will allow me to define the Table I want to pull the data from.

Any Ideas?

 

[MattS]

I would probably do this in code. Have a combo box listing all the possible source tables, and then put some code behind a command button.

Something like:

Dim strSQL As String

strSQL = "SELECT field1, field2, field3 INTO tblYourNewTable FROM " & combobox.value

DoCmd.RunSQL strSQL