Combo box to Select Table to Query

[RedWolf3x]

I have several linked tables that I'm trying to Query

January through December

I have a Query



Select * from November
(That's not my query, but it gets my point across)

What I'm looking to do is have a Combobox that will change which table the Query is running.

Select * from (whatever table my combobox says)

Is it possible? and if so how?

I'm trying to avoid having to rewrite the query for each month and use VBA to select which Query to run

[pbaldy]

It won't be easy, because your design is not normalized. Data should be in one table, with a date or month field. That lets you query data out with a simple criteria for any month or combination of months. To do what you're describing, you'll need to create or modify the query in code. Searching on QueryDef should turn up similar code.

[RedWolf3x]

Thank you, Your response gave me an idea that I had not though of.

I created a Union query combining all the data from the tables, then used the query to filter it out.

Thanks.

RedWolf3x

[pbaldy]

No problem. The union query is basically normalizing the data.