jarheadjim
03-06-2002, 06:38 AM
I'm making a database to keep track of items checked in/out of my work-center. But I only need to track items for the last 90 days from the "date out". If anyone could point me in the right direction I would appreciate it. Thanks
Jack Cowley
03-06-2002, 08:38 AM
If you want to delete the records then a delete query with <=Date()-90 in the dates criteria field will do the trick. Or you can use the same criteia to view only data from the last 90 days and not delete the records.
jarheadjim
03-06-2002, 09:11 AM
I did that, and it works too well! It deletes entries I made today as well as old ones. I placed the argument next to "criteria" and I ensured that I had "when" selected from the pulldown menu. Any further guidence?
David R
03-06-2002, 10:08 AM
>= Date()-90 to VIEW records within the last 90 days.
< Date()-90 to DELETE records older than 90 days.
I would run even your delete criteria as a select query first to see if it's selecting the right records.
If that doesn't fix it, post the SQL of your query here (View>SQL, Copy, Paste here)
HTH,
David R