P
paulpenta
I have a table called Perf_table. It is updated manually from another "temp"
table using an Append query. This allows the table bound to the data entry
form to be empty at the beginning of each session.
The records appended are then QC'd. Once they pass this level, they are
appended to another final table for review by the decision makers. After this
last append, I clear out the appended records with a delete query which uses
the checkbox used by the QC person to indicate approval as the creterion for
which records get deleted.
I delete them so that subsequent "appends" to the final table don't get
duplicate records. Is there any way to RunCommand Backup before the delete
query so i can keep "safety" copies of all records?
Thanks
table using an Append query. This allows the table bound to the data entry
form to be empty at the beginning of each session.
The records appended are then QC'd. Once they pass this level, they are
appended to another final table for review by the decision makers. After this
last append, I clear out the appended records with a delete query which uses
the checkbox used by the QC person to indicate approval as the creterion for
which records get deleted.
I delete them so that subsequent "appends" to the final table don't get
duplicate records. Is there any way to RunCommand Backup before the delete
query so i can keep "safety" copies of all records?
Thanks