0
0421
hi,
I had a query that will gives me as follow :
INV# ITEM# QTY $COST $SALE/unit Profit
1001 7789 1 1.00 5.00 4.00
1001 6532 1 10.00 10.00 0.00
since each item will have a new record even they are in the same invoice,
what do I have to do to have the query add up the profit and show in a new
column as long as the record have the same invoice# ?
Thanks
0421
I had a query that will gives me as follow :
INV# ITEM# QTY $COST $SALE/unit Profit
1001 7789 1 1.00 5.00 4.00
1001 6532 1 10.00 10.00 0.00
since each item will have a new record even they are in the same invoice,
what do I have to do to have the query add up the profit and show in a new
column as long as the record have the same invoice# ?
Thanks
0421