DATETIME Function

  • Thread starter Thread starter dswiders
  • Start date Start date
D

dswiders

I have a Macro and at the end of the Macro I have a Make Table Query
that I would like to automatically save as todays date in the current
database. I know there is a DATETIME function but I don't know how I
can use this to save as the table name. I thought about setting a
variable as the current date and then saving the table as the name of
that varible. I am not familiar with this type of programming does
anybody have an idea on how I can do this?
 
That is not the correct way to do it. It would be better to add a field to
a single table with a field to store the data the record was added to the
table. Then, rather than a make table query, use an append query to add the
records to that table.
 
Back
Top