An Entry's Age

[gobeav3rs297]

Hello,

I've posted a few times in here already and i'm a newbie at Access but anyway i've within my table a field called 'Date Added' and everytime a new entry is created a date will be added to that field. What i want to do is everytime that access file is opened or at least somekind of schedule implemented i want it to run a background check to see if any entries in that table is at least 10 years old, if it is then it should pop a message displaying those entries to the user and then delete them. I found a few posts that i think will kind of help me but like i said before i'm quite new to Access so any help would be great.

 

[macca the hacke]

The easiest way would be to set up table so that when it is updated you also update a field in the table with the current date/time.

Simple delete query searching for those where this field is over 10 years ago would work.

Obviously this won't work for 10 years.......................