eliminate

[marfado]

i want to eliminate records on a date/time field that are 5 days older than
current date.
I apreciate some help. thanks

 

[Ken Snell]

Run a delete query similar to the following:

DELETE * FROM TableName
WHERE DateDiff("d", [DateFieldName], Date()) >=5;

 

[Aaron Yang]

Click Mouse right button,POP menu,select" Exclude Filter",input below
expression:

#date()-1#

then enter.....OK?

Aaron _~@
Yang _`\<,_
¡¡ (*)/&(*)
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~