Auto Delete record after 3 years?

[maxx102]

Hello,

I have a question. I am updating our company's parking database which includes all of the parking tickets and fines we have issued. We currently have a function button that changes the status from say "parking in handicap space" to "VOID - ticket 1 year old - VOID".

What I would like to do is something very simular to the steps I mentioned above except instead of just changing a field status, it deletes the whole record after 3 years of the parking ticket issue date. (1095 days)

Is there a way for me to program the function button to do this and if so, how do I do it?

[RuralGuy]

How about Archiving the records? http://allenbrowne.com/ser-37.html

[maxx102]

We really don't need or want to store the records for more than 3 years. I can do this by hand by selecting the whole line of data the covers all of the various fields, but if there is a way I can program a button to do it for me, that would be a lot easier and quicker.

[RuralGuy]

I would use the Query builder and see if you can build a query that selects just the records you want. After you get just the records you want then change it to a Delete query.