Delete query with date criteria

[Moore71]

Hi,
i have 2tables,table1 id,name, table2 id,name,date.
How can i write a delete query that will delete everything in table2,if the data date is today?
Please i need sql statement or vba code
thanks

 

[Gasman]

I would use the Query wizard to build the code.
However at a guess

DELETE * from Table2 where table2.date = date()

the query wizard would give me this for my Dates table (substitute your table name and field names)

DELETE Dates.On_Date, Dates.*
FROM Dates
WHERE (((Dates.On_Date)=Date()));

 

[burrina]

Oops, too slow.