Having Access automatically naming a table bassd on date and time

[meagain]

I'd like to create a macro that creates a new table and gives it the name according to the date and time. Is this possible, and how would I go about telling Access (2002)
how to name the new table?

Thank you!!

 

[SkipVought]

Hi.

Table.name = format([somedatetime],"yyyymmddhhnnss")

But I am suspicious of tables named with data element values. What's the purpose of creating & maning these tables? What will they store?

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}