Make Table Query Question

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

I have a Make Table query which uses a date parameter.
Each time the user runs the query they will be prompted
for a date. The table which is created should be named
based on the date which they entered. For example: The
query will retieve all invoices dated xxxxx, the user
will may supply the date of Jan 1 2004. It should create
a table called "Jan 1 2004 Invoices" (or something like
that). Each table created needs to be saved in the
database with an appropriate name. How can I have the
query create a table with a name based on the date input?
 
I have a Make Table query which uses a date parameter.
Each time the user runs the query they will be prompted
for a date. The table which is created should be named
based on the date which they entered. For example: The
query will retieve all invoices dated xxxxx, the user
will may supply the date of Jan 1 2004. It should create
a table called "Jan 1 2004 Invoices" (or something like
that). Each table created needs to be saved in the
database with an appropriate name. How can I have the
query create a table with a name based on the date input?
Click to expand...

Only by writing VBA code to construct the SQL string, and then
executing it.

One BIG question: what EARTHLY good will such a proliferation of
tables do you!? If you have a Query which returns all your invoices,
you can create a Query selecting those records with Jan 1 2004. That
Query can be used for a Form, for a Report, for export... what benefit
do you get from storing (potentially 280 or 366 a year) new tables in
your database, with data that you know to be redundant?
 
Back
Top