Filtering out duplicate data point?

[Guest]

Hi:

I have not worked with MS Access in a while (5 yrs) and need help to filter
150,000 data points. I am trying to determine unique entries base on several
key criterias. I did import the data from our database with ease. Any help
would be great.

Thanks,

Hank

 

[Michel Walsh]

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