finding unique occurences of a record in a table

[baquist]

Hi,

I have a table which has duplicate records. I can tell which are the duplicates by using the find duplicates query, but I need to be able to get a table with a unique occurence of each record. I can do this in SAS using the sorting procedure with the 'nodupkey'; how does one do this in Access? The unique identifier will be the social security number.


Appreciate any help!


Baquist

 

[baquist]

I think I found a workable solution - (by reading some other posts, sorry about that! ) I added 'distinct' after the word 'select' in the SQL view. It seems to have worked!


Baquist