Remove Duplicates but keep Uniqe identifyer??

[mkelly]

I have a table of 50,000 reccords. The table has 8 fields of theses eight fields I want to remove duplicates based on 4 of the fields in a query. Is there a way I can do this and keep the uniqe identifyer so that after the duplicates are removed from those 4 fields I can match them back up with the other four fields????

 

[mkelly]

OK I got it must of had a brain fart I used an append query and made the four fields my key.

thanks anyway...