How to remove a row if one field is duplicated?

[HeyMoe]

Is there a way to remove a whole row of data if one of the fields is duplicated?

eg. The query returns this:

Col1 Col2 Col3 Col4
A C D E
B G F Z
C H K V
D H Z S

I want to not show the last row of data because Col2 has 'H' appear twice.
Is there a way to do this?

Any help would be appreciated.
Thanks.

 

[Khalid_Afridi]

And also...
to prevent duplicate entry to be happened, you can create multiple Primary keys for certain fields with set noDuplicates to yes.
so the combination of those fields will not allow to enter duplicate data in the table.

Khalid