title: I need to delete a record based on duplicate usernames and different content in another column
body: <p>I am using Access 2016.
  I have a database that keeps track of all employees and what Safety training they have taken.
  I need to figure out a query that looks for duplicate usernames (column is called mis_user) and if it finds a duplicate username, it needs to delete the record that contains Crisis Intervention Medium and High Risk in the column: object.</p>
  <p>The table is called: 1-DC-Crisis_eLearn_HRIS_Combined</p>
  <p>In the example image attached, AbSmith is in column mis_user twice. Look in the next column (object column) and you can see that AbSmith has taken the Medium and High Risk course, as well as the Re-Certification (All Level) course.  So, for AbSmith, I need to delete the record that contains Crisis Intervention Medium and High Risk. <a href="https://i.stack.imgur.com/LlKPv.png" rel="nofollow noreferrer">image showing the columns </a></p>
  <p>Does anyone have any ideas how this can be done?
  I appreciate any and all help.
  Thank you
  Deb :)</p>