emanuele the old good fellow Bill Local time Today, 17:53 Joined Jan 23, 2003 Messages 23 Jul 18, 2003 #1 in a db I would like records from a tbl to be automatically deleted when they are older than 3 years. my records are stored by "Year((date))" #9999# any ideas? Thanks
in a db I would like records from a tbl to be automatically deleted when they are older than 3 years. my records are stored by "Year((date))" #9999# any ideas? Thanks
Mile-O Back once again... Local time Today, 16:53 Joined Dec 10, 2002 Messages 11,305 Jul 18, 2003 #2 How about...a Delete Query! If you want it three years from the current date, you can set the criteria to be: <DateAdd("yyyy", -3, Date())
How about...a Delete Query! If you want it three years from the current date, you can set the criteria to be: <DateAdd("yyyy", -3, Date())
emanuele the old good fellow Bill Local time Today, 17:53 Joined Jan 23, 2003 Messages 23 Jul 19, 2003 #3 one more inch? Hi Phile, thanks for your reply. I just need one more little advice: How do I make a Delete Query? Sorry for being such a beginner
one more inch? Hi Phile, thanks for your reply. I just need one more little advice: How do I make a Delete Query? Sorry for being such a beginner
Mile-O Back once again... Local time Today, 16:53 Joined Dec 10, 2002 Messages 11,305 Jul 19, 2003 #4 Build the query as normal and then, in one of the menus there is the option to specify the type of query i.e. Delete, Append, MakeTable, etc. Just select Delete query.
Build the query as normal and then, in one of the menus there is the option to specify the type of query i.e. Delete, Append, MakeTable, etc. Just select Delete query.
emanuele the old good fellow Bill Local time Today, 17:53 Joined Jan 23, 2003 Messages 23 Jul 19, 2003 #5 Grazie. (means thank you in italian)
