Delete queries deleting the last 30 days

[gcorsey]

I have created an Append query and a delete query. I need a date function for the delete query to delete the last 30 days. Can anyone help?:banghead:

 

[jzwp22]

Assuming that you have a date field in your table, you would just add criteria to the DELETE query as follows

WHERE yourdatefield between date() and dateadd("d",-30,date())

 

[John Big Booty]

Have a look at the DateAdd() function.