Use a GROUP BY query. List, in the group, the fields that, together, define
'being unique'.  In the select clause, aggregate other fields that 'goes'
with the fields in the group, without defining what is to be consider in
being unique, with LAST  (or with FIRST):

f1        f2        f3                'fields
10    QW       Joe Smith
10    QW        Smith, Joe
11    QW        Mary Ann        ' data

SELECT f1, f2, LAST(f3)
FROM mytable
GROUP BY f1, f2

will return one of the first two record, plus the third record.  Here, f1
and f2 defines what is unique, and f3 is just an 'associated' information.

Hoping it may help,
Vanderghast, Access MVP