I am trying to add up all the payments from a customer and then deduct them from the total loan amount the customer owes to show a current balance. I have created a query that adds up the payments but when I try to calculate this it only will deduct one payment from the total loan amount. Can you tell me how to fix this please? Thank you, Jimmy
Reply from Alex Hedley:
What do your Queries look like?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.