Filter out Duplicates

[Ste4en]

I have a table which contains some duplicate records - some fields duplicated, some different for example:

Equip_No, Name
121X, shaft
123X, motor
123X, motor starter
124X, timer

I want a query filter so that only one of the 123X rows so I have a unique list of Equipment Numbers, I also need the Name (any one of the two will do)

Equip_No, Name
121X, shaft
123X, motor starter
124X, timer

OR

Equip_No, Name
121X, shaft
123X, motor
124X, timer

WOULD WORK

Any Ideas?

Thanks

 

[Roelof]

You could make a query with the numbers on "group by" and the name on "min".

Roelof

 

[maxmangion]

use the word DISTINCT in your SQL statement.