Deleting data automatically

[Arcadia]

I want to make a query that can delete flights that are older than 60 days automatically but i don't know what value i have the use in the criteria box

I really hope someone can help me out with this

 

[Mr. B]

Give this a try in the criteria of your flight date field in your delete type query:

<DateAdd("d",-60,Date)

This function says return or delete only records where your flight date is less than the current date minus 60 days. Those are the records that will be deleted.

 

[Arcadia]

No it does not work

It says that it is a wrong code.

 

[Mr. B]

Sorry, I left something out. Please try this:

< DateAdd("d",-60,Date())