Urgent Help Needed - Query to remove duplicates

[kamkashem]

Hi Guys,

I am fairly new to access and would like some help which i think is probably very easy to do.

I have a table which looks similar to this

ID Name Address Score
1 Joe Address1 9
1 Joe Address1 8
2 Carl Address2 9


basically it is a table with duplicates, all i want is to be able to strip out all the duplicates and only have one instance of an ID - i dont care what the score value is aslong as i just have Joe once..

Can it be explained using query wizard pls

 

[MStef]

1) Make another table with the same fields.
2) In this table make ID = Primary key.
3) Make an append query. Input is your table, output is this another table.
4) Run this query.
5) Delete first table.

 

[kamkashem]

1) Make another table with the same fields.
2) In this table make ID = Primary key.
3) Make an append query. Input is your table, output is this another table.
4) Run this query.
5) Delete first table.

Thank you!