Hi Alex, in the process of building my database I noticed that every time I put a payment in the database it would deduct form the balance. What I have noticed is that if I have customers that pay weekly and give me permission to auto debt their account. I normally put all the weekly payments for the current month into the system on the same day so I don't have to do it every week.When I do this the balance goes down by the number of payments I have input into the database even though the due date isn't for the next three Fridays. How can I prevent this from happening so that Im looking at the correct balance every time I look at a customers record. I want to be able to see the payment on the date due and either "post" or "decline" the payments as they are due.

---

Reply from Alex Hedley:

You could change the Query that shows payments to show only records before today so it cuts off future ones.