By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

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

100+
P: 759
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 !
Feb 18 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
I don't believe you can Mihail. That would be the time to start using SQL I suspect.
Feb 20 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.