This is just a small subset. There are dups in the table.



>I don't see any duplicates here...
>
>>Sorry, I should have clarified that.
>>
>>If the Title, Table and Field combination appears more than once, then it's a duplicate.
>>
>>>What is the definition of a duplicate here?
>>>
>>>>I have a table with this structure:
>>>>
>>>>

>>>>Sec Tp Title                         Table      Field
>>>>---------------------------------------------------------
>>>>    CR cash balance between 300.rpt  trades     tradedate
>>>>    CR cash balance between 300.rpt  trades     valuedate
>>>>    CR cash balance between 300.rpt  cust       acctname
>>>>    CR cash balance between 300.rpt  trades     conf_num
>>>>    CR cash balance between 300.rpt  trades     product
>>>>    CR cash balance between 300.rpt  trades     quantity
>>>>    CR cash balance between 300.rpt  trades     price
>>>>    CR cash balance between 300.rpt  trades     ext_price
>>>>    CR cash balance between 300.rpt  trades     productbal
>>>>    CR cash balance between 300.rpt  trades     cash_bal
>>>>3.1 CR invoice prior posting.rpt     trades     product
>>>>3.1 CR invoice prior posting.rpt     trades     quantity
>>>>3.1 CR invoice prior posting.rpt     tranfile   tranquant
>>>>3.1 CR invoice prior posting.rpt     prods      prodesc
>>>>3.1 CR invoice prior posting.rpt     trades     price
>>>>3.2 CR open customer positions.rpt   trades     tradedate
>>>>3.2 CR open customer positions.rpt   trades     tradetype
>>>>3.2 CR open customer positions.rpt   trades     product
>>>>3.2 CR open customer positions.rpt   trades     quantity
>>>>3.2 CR open customer positions.rpt   trades     price
>>>>3.2 CR open customer positions.rpt   trades     net_amount
>>>>3.2 CR open customer positions.rpt   trades     cash_bal
>>>>3.2 CR open customer positions.rpt   trades     conf_num
>>>>3.2 CR open customer positions.rpt   trades     productbal
>>>>3.2 CR open customer positions.rpt   trades     valuedate
>>>>

>>>>
>>>>How do I remove the duplicate rows?