Create more than one table using the same Make-Table query

[Mihail]

Hi all !
What I have:
In a BE database I use a temporary table to store some data.
Of course, for different filters that data will be different.
Keep in mind, please, that the table structure is not changed. Only data.

In a FE database I have
- A make table query based to the temporary table from BE. This is a simple query which simple transfer the temporary table from the BE to FE
- 2 command buttons: cmdStore_1 and cmdStore_2

What I wish:
- To run once my BE (with a filter) => to obtain a set of data in the temporary table then, to return to FE and press cmdStore_1 in order to run my query and to create Table_1.
- To run again the BE (with a new filter) => I obtain a new set of data in the temporary table then, to return (again) to FE and press cmdStore_2 this time in order to create Table_2.

So the question is:
How to pass the variable TableName to my (single) Make-Table query in order to obtain different tables.

Of course that can be easy managed using SQL in VBA.
But I prefer to use a "really" query because my poor skill in SQL don't allow me to easy change the SQL if needed (for code maintenance).

Thank you !

[NeoPa]

I don't believe you can Mihail. That would be the time to start using SQL I suspect.