G
Guest
I have a customer table “Sales” with total
sales as of last month. I would like to
update this table with sales/returns. Sample:
Sales A 130 Sales/returns A 10
B 120 B 20
B -10
C 50
The result in the Sales table should be
A 140 (130+10)
B 130 (120+20-10)
C 50 (add a new record)
Any Ideas?
sales as of last month. I would like to
update this table with sales/returns. Sample:
Sales A 130 Sales/returns A 10
B 120 B 20
B -10
C 50
The result in the Sales table should be
A 140 (130+10)
B 130 (120+20-10)
C 50 (add a new record)
Any Ideas?