Hi there!
I am creating a database for tracking training at my workplace and have run into some trouble with archiving old training records.
Basically i would like to create an append query that i can use to move previous training records to a separate table when i add a new training record. For example:
Employee Number: 12345 Name: Jane Smith Training: Anti-Bullying Completed: 10/12/2020 Expires: 10/12/2021
so if the above record is in the Anti-bullying table, and Jane completes her annual Anti-Bullying training and i want to add the updated record to the table and move the other record into an archive table. Sorry, i am very much a beginner at MS Access.
I guess i am just wondering what criteria would i put in the append query if i wanted to move a record with duplicate employee number but remove the one with the earliest completion date.
thanks for your help!
I am creating a database for tracking training at my workplace and have run into some trouble with archiving old training records.
Basically i would like to create an append query that i can use to move previous training records to a separate table when i add a new training record. For example:
Employee Number: 12345 Name: Jane Smith Training: Anti-Bullying Completed: 10/12/2020 Expires: 10/12/2021
so if the above record is in the Anti-bullying table, and Jane completes her annual Anti-Bullying training and i want to add the updated record to the table and move the other record into an archive table. Sorry, i am very much a beginner at MS Access.
I guess i am just wondering what criteria would i put in the append query if i wanted to move a record with duplicate employee number but remove the one with the earliest completion date.
thanks for your help!