General discussion

Locked

DUPLICATE RECORDS

By GW0001 ·
I have a table with 2 fields: part# and qty.
I have records that have the same value in the "part#" field. I would like to remove these duplicates, so I have 1 record with the total of the values from the "qty" field (from each of the matching records)

Thanks

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by ReWrite In reply to DUPLICATE RECORDS

You can accomplish this with a sum query. It should look something like this:

select part#, sum(qty) from tbl
group by part#

You can also add an "order by" clause to sort the results by part#.

Cheers.

RW

Collapse -

by GW0001 In reply to

Works perfect - Thanks! This will help alot.

Collapse -

by GW0001 In reply to DUPLICATE RECORDS

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums