I have a Make Table Query that I will need to run every morning. Is there
anyway to have the query add today's date to the name of the table (without
going in and changing it everyday) so that the new table won't overwrite
yesterday's table?

=?Utf-8?B?SkQ=?= wrote:

>
> I have a Make Table Query that I will need to run every morning. Is there
> anyway to have the query add today's date to the name of the table (without
> going in and changing it everyday) so that the new table won't overwrite
> yesterday's table?

In VBA you can use a command like:
DoCmd.RunSQL "SELECT * INTO T" & Format(Date, "yyyymmdd") & " FROM T1"

--
Groeten,

Peter
http://access.xps350.com