Remove Duplicates

[Capo]

If have a table with billing occurances and one of the fields is "business name" how would I need to setup a make table query which lists unique occurances within that data?

Essentially, I want to remove duplicates. If ABC Pet Store has 5 billing occurances and XYZ Pet Store has 1... I want both to only be listed once.

I hope that makes sense. Thanks for any help as to how to set this up!

 

[Capo]

I think I figured this out... please let me know if my logic is correct here.

If I create a new table with the same structure, assign the "business name" as the primary key, and then do an append query from the old to the new table, I should be able to remove the duplicates as that the primary key will prevent duplicates from being present...

Is that correct or am I off somewhere?