Make Table Query - Save Table as Date

  • 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. Does anybody have an idea on how I can do this?
 
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. Does anybody have an idea on how I can do this?
Click to expand...

A date is just a field value. Saving today's date as a Table is almost
certainly VERY bad design. Why do an expensive, awkward MakeTable query at
all? Store the day's data for all days in *one* table, with a date field
defaulting to Date(), and then use a Query to select the records pertaining to
a given day.

If I'm misunderstanding what you're trying to accomplish please explain!

John W. Vinson [MVP]
 
Back
Top