T
tradmusic
Hi,
Is it possible to set up a query / macro that automatically deletes records
held in a particular query table?
For example, I wanted to have a Yes/No field in my database that would
basically be an Include / Delete option - if ticked, then that record would
be pulled into a query table of Deleted records.
Of course, they're not deleted, they are just marked as such - so is it
possible to then create a command that will delete out, maybe weekly or
something, all records held in the Deleted Records query table?
Hope that makes sense!
Nath.
Is it possible to set up a query / macro that automatically deletes records
held in a particular query table?
For example, I wanted to have a Yes/No field in my database that would
basically be an Include / Delete option - if ticked, then that record would
be pulled into a query table of Deleted records.
Of course, they're not deleted, they are just marked as such - so is it
possible to then create a command that will delete out, maybe weekly or
something, all records held in the Deleted Records query table?
Hope that makes sense!
Nath.