Q: now() in tablename for make table query?

M

MarkD

I know I can do this from code, but is there a way I can
set up a query maketable object so that it adds today's
date to the table name?

What we really want is the ability to double click on a
query object, and have that create a table with today's
date. So, as long as it's transparent to the end user,
using VBA is okay. I just don't want to create a form or
have them open a debug window because they usually just
double-click on the desired query.

Thanks!
-Mark
 
Top