QUERIES

[Liz Morrin]

THANK YOU FOR YOUR IMMEDIATE RESPONSE TO MY QUESTION. IT WORKED.

NEXT QUESTION: I am trying to subtract payments received from a total and get a
balance. What expression is used for this.
I've tried everything.

Any help will be greatly appreciated.

Thanks.

 

[jatfill]

I'm assuming your payments table accepts multiple payments per account...

you need to create a query which groups by the account or other unique identifier on the payments table. Also, cross-reference or add the total you referred to, then create a new column that has this as the expression:

(Sum([payment_received_amount])-[total])

Again, this will update every time the query is run...

let me know more specifics if this doesn't fit into your current structure...