Make Tbl Qry that includes (now) date in TblName?

jgabel

Registered User.
Local time
Today, 14:06
Joined
Mar 29, 2012
Messages
42
Is it possible to perform a make table query that includes the date in the table name without having to type in the date? For example if the current make table name makes tbl EMPLOYEES, can I have it include the date like:

"EMPLOYEES 2012-04-20"

Each time I run the make table I want the name to always be EMPLOYEES, but I want the current date to be added to the table name as a way that I can historically store the tables, I'm okay with overwriting the table if I run it several times a day.
 

Users who are viewing this thread

Back
Top Bottom