Question Adding Problems (1 Viewer)

[jc_]

Is there a formula or another way to total same customer information. Ex: Customer1 has 3 different payments: 10$, 20$, 30$... how do i sum these up? In my qry it just has Customer1 listed 3 different times with each payment individually and I only want each customer listed once with all combined payments....

Thanks!

 

[jc_]

i want to be able add up the numbers by customer. I understand the total query from the sigma button. I did that for 'invoice', but it isnt working. for every invoice it duplicates cash receipts. it still shows the customer listed 3 times and in design view it says total: sum..???