Access Query has Duplicates

[TimC]

I am trying to create a query that pulls data from a thirdparty’s tables. The location code andlocation description are not primary keys AND are directly linked to other information within the table.
I've created the table but get lots of duplicates. Is there a way to hide the duplicates? See example below.If so, could you please provide step-by-step instructions?Thanks.

Org1Cd	Org1Desc
79	Ottawa Street
79	Ottawa Street
79	Ottawa Street
87	Michigan Ave
87	Michigan Ave
87	Michigan Ave

[orange]

This is a situation where posting some related code would be helpful.

[TimC]

The duplicates repeat about 16,000 times even though there are 22 actual names. What kind of code would you suggest? Can you provide something that I might be able to cut and paste into visual basic? Thanks.

[CJ_London]

without seeing your code, try using something like

SELECT DISTINCT fld1, fld2
FROM myTable