Updating customer record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a customer table with total sales that I would like
to update with sales/returns. Sample:

Customer A 130 Sales/returns A 10
B 120 B 20
B -10
C 50
The result in the Customers table should be

A 140
B 130
C 50
Any Ideas?

Thanks
 
This is too vague. Please add details. What field holds the total? what
field holds the sales/returns? Are the sales/returns in different tables?
etc., etc. etc.
 
The Customer tble has total customer sales as of
yesterday. THe sales/returns tbl has sales for today
(includes new customers). I would like to update the
customer table with the results i.e., Sales+sales/returns
and also add any new customers to the customer tbl.
 
Back
Top