Remove Duplicates but leave the unique

[parthiv]

Hi,

I have a following table in MS Access 2007 where I want to remove the duplicates (from a column - "Merge") from it but leave all the unique values in it. Thanks heaps for looking into it.



Table Name=Disc_Analysis
ID | Name | Date | Amount | Merge
1 | Adam | 05/05/2015 | $55 | 1Adam5555
2 | Ram | 07/04/2014 | $400 | 2Ram4525
3 | Roy |05/05/2015 | $55 | 1Adam5555
4 | Mat | 07/11/2014 | $499 | 4MatCBOM

I want to see the following as my result table.
ID | Name | Date | Amount | Merge
1 | Adam | 05/05/2015 | $55 | 1Adam5555
2 | Ram | 07/04/2014 | $400 | 2Ram4525
4 | Mat | 07/11/2014 | $499 | 4MatCBOM

Thank you so much in advance.

[CJ_London]

You need to be clearer

there are no duplicates in your data - record 3 is not the same as record 1 - and if they are to be treated the same do you mean duplicate date/amount/merge and ignore name? And if this is the case - why choose 'Adam' over 'Roy'