How do I create a query that deletes all records 2 weeks old?

[Guest]

I have records created by form entries. I need records to delete two weeks
after the [Initial Call Date]. So far it looks like I need to create a Delete
Query. Now I am thinking I needed to use the DateAdd with the [Initial Call
Date] requiring a new field Deletion Date. If this is correct I can't figure
out where to put the DateAdd expression.

What is the best way to do this? Also, can queries somehow run automatcially
so that these records will be deleted automatically? Or will I have to run
the query manually?

Any help is greatly appreciated!!

Thanks!

 

[Joseph Meehan]

I have records created by form entries. I need records to delete two
weeks after the [Initial Call Date]. So far it looks like I need to
create a Delete Query. Now I am thinking I needed to use the DateAdd
with the [Initial Call Date] requiring a new field Deletion Date. If
this is correct I can't figure out where to put the DateAdd
expression.

What is the best way to do this? Also, can queries somehow run
automatcially so that these records will be deleted automatically? Or
will I have to run the query manually?

Any help is greatly appreciated!!

Thanks!

Use the delete query. Make sure you are recording the date the initial
call is made and that it is not changed. Don't add a delete date. Just use
a criteria on the delete query looking for any dates greater than 14 days
before =DATE()