lingtrin
asked on
Sumarizing data
Hi I have a table where inventory transactions are saved, what I want to do is to sumarize all movement's for each item.
Something like this:
Table Inventory transactions:
Part No. TrxQty
001 100.00
001 20.00
001 150.00
002 200.00
002 300.00
003 50.00
004 100.00
And on the report I want to show something like this
001 270.00
002 500.00
003 50.00
004 100.00
A total every time the part no. changes, with out showing every movement for each part no. on the table.
Hope I made my self clear
Thanks to all in advance
Something like this:
Table Inventory transactions:
Part No. TrxQty
001 100.00
001 20.00
001 150.00
002 200.00
002 300.00
003 50.00
004 100.00
And on the report I want to show something like this
001 270.00
002 500.00
003 50.00
004 100.00
A total every time the part no. changes, with out showing every movement for each part no. on the table.
Hope I made my self clear
Thanks to all in advance
select part_no, sum(TrxQty) from inventory_table group by part_no order by part_no
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great, I knew it was going to be something simple, but since i'm new on this, I didnn't know
Thanks CRXIuser2005
Thanks CRXIuser2005
Glad I could be of assistance...
MikeV
MikeV