Removing Duplicate Records

[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!

 

[John R. Baker]

Make the three fields "Name", "Course", and "Passed" be a combined PRIMARY
KEY with NO DUPLICATES ALLOWED.

- John R. Baker