SQL append query to use date stamp?

[shermy448]

Hello,

I have tables date stamped every day EG. TABLE20060403
Is there a way in sql to append to a master table using todays date in the query ?
My current query is :

INSERT INTO table1
SELECT TABLE20060403.*
FROM TABLE20060403;

which I have to change manually every day.

Tks
shermy448

 

[PHV]

Do it in VBA:
DoCmd.RunSQL "INSERT INTO table1 SELECT * FROM TABLE" & Format(Date, "yyyymmdd")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shermy448]

Thanks PH - Perfect first time