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)