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.
"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.