Hi there got a query that has about 1000 records... but is made up about 400 customers. I would like to add the balance of each customer if possible... ex:
Coulmn A Column B
SSN Balance
222-22-2222 $500.00
111-11-1111 $600.00
222-22-2222 $1,000.00
222-22-2222 $300.00
so the end result would be:
Coulmn A Column B Column C
SSN Balance Total Balance
222-22-2222 $500.00 $1,800.00
111-11-1111 $600.00 $600.00
222-22-2222 $1,000.00 $1,800.00
222-22-2222 $300.00 $1,800.00
Anyone know how to do this??? I know I can create a report to do this but I'd like it in a query...
Bookmarks