Parameters in the Name of a table from a Make-Table Query

[Bobby Internet]

Hi

I want to run a make table query which includes today's date automatically.
I figure I could either add parameters for the make table name from a button
on a form (which I couldn't get to work) or to automate a date append to the
name of the made table.

My VB is rubbish, but I am OK with Macro's, forms and text boxes, so if
someone could please give me some step-by-steps I would appreciate it.

Thanks

Bob

 

[Gary Walter]

Hi Bob,

You just need to add Date() to the
maketable query if I understand
correctly.

SELECT ....., Date() AS MakeDate
FROM sometable
INTO someothertable;

If you were looking at your maketable
query in query designer,

in a new column of your grid

Field: MakeDate: Date()
Table:
Sort:
Show: <checked>
Criteria:

Please respond back if I have misunderstood.

Good luck,

Gary Walter