QUERIES (1 Viewer)

L

Liz Morrin

Guest
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

Registered User.
Local time
Today, 12:35
Joined
Jun 4, 2001
Messages
150
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...
 

Users who are viewing this thread

Top Bottom