Hello all, this is my first post, so thank you for your help in advance.
We use an on-line survey to ask our students to let us know any new medical details they have. I download and convert to excel, and import in to a table called “Current Medical Details”. If a record already exists, the database automatically produces a “Paste Errors” table.
What I would like to do, is delete the records from the current Medical Details table using the records from the Paste Errors table, so that I can re-import the most up to date information.
The two unique fields are “F1” in Paste Errors and “1 Student number:” in Current Medical Details.
Thank you.
We use an on-line survey to ask our students to let us know any new medical details they have. I download and convert to excel, and import in to a table called “Current Medical Details”. If a record already exists, the database automatically produces a “Paste Errors” table.
What I would like to do, is delete the records from the current Medical Details table using the records from the Paste Errors table, so that I can re-import the most up to date information.
The two unique fields are “F1” in Paste Errors and “1 Student number:” in Current Medical Details.
Thank you.