Make Table Query Table name restrictions

[azpat via AccessMonster.com]

Is there any way to create a table name in a make table query that will
include the date?
I want to have a history of tables and would like to have the date as part of
the name ie DivAll20061226.

If it cannot be done in the query, can it be done with a rename macro?

Pat

 

[Jeff Boyce]

Pat

If I understand your description, you are trying to make a copy of a table
and add something like a date/time stamp as part of the name.

Why?

You've described a solution you want to use, but not the reason why you need
a solution. I'm not inquiring to be difficult, but to see if there might be
an easier solution to whatever it is you are trying to solve.

For example, if this is your way of keeping a history of RECORDS, you might
be able to do that by simply adding a date/time field to the table. Then,
if you don't want to see "old" records when you query that table, exclude
any records with an "old" (your definition of how old) date/time value.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/