Need To Sum Payments in Query

[burrina]

I have a query that shows me if a Customer has a Balance greater than zero. I would also like to be able to see the Total Balance for this customer.
The query is a select query and I would like to keep it that way if possible.

Here is a snapshot of the query. The field I need the total from is named (Payment)

[alansidman]

Are you running this query against one customer at a time?

[burrina]

NO. I did not limit it to that criteria since it is just a way to view ALL Customers with their Total Balance.

[alansidman]

If you wish to see the detail and the sub-totals for each client, then have a look at this tutorial as it is a means to accomplish that.

http://www.datapigtechnologies.com/f...nionquery.html

Alan