Removing Duplicate Records

  • Thread starter Thread starter Jasmine
  • Start date Start date
J

Jasmine

I am importing information into Access from another
program. I am trying to figure out how to remove
duplicate records once I get it into Access. The records
contain Name, Course and Passed columns. A particular
course may be entered twice for that user and I need to
get rid of the second entry. Here is an example of what
the data might look like:

Name Course Passed
Smith 123 Yes
Smith 1234 Yes
Smith 123 Yes
Jones 123 Yes


There are two entries for course 123 for smith. I need to
get rid of one of them. I would appreciate any help!
Thanks!
 
Make the three fields "Name", "Course", and "Passed" be a combined PRIMARY
KEY with NO DUPLICATES ALLOWED.

- John R. Baker
 
Back
Top