kbrooks
Still learning
- Local time
- Yesterday, 20:06
- Joined
- May 15, 2001
- Messages
- 202
I have a database I set up for a department to keep track of charts they send out, where they go, and when they're returned. There is getting to be a LOT of records in the database, so I'm wanting to set up some kind of purge function for them.
I know I can set up a delete query but I have a couple questions. The date we'll go from is called returned_date, and they want to delete records that were returned 6 months ago or longer, and keep all records returned within the last 6 months. I'm not sure how to do this, other than having them manually calculating the date 6 months ago, and prompting them to enter it when running the query. Is there an easier way?
Also they want to view the reports before deleting. I was thinking of setting up 2 separate queries that are exactly the same.....only one will be a delete query and the other one won't. Then I can just make a report based on that query. Is that the best way?
Thanks in advance!
I know I can set up a delete query but I have a couple questions. The date we'll go from is called returned_date, and they want to delete records that were returned 6 months ago or longer, and keep all records returned within the last 6 months. I'm not sure how to do this, other than having them manually calculating the date 6 months ago, and prompting them to enter it when running the query. Is there an easier way?
Also they want to view the reports before deleting. I was thinking of setting up 2 separate queries that are exactly the same.....only one will be a delete query and the other one won't. Then I can just make a report based on that query. Is that the best way?
Thanks in advance!