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?