Important option for balance query.

Question

Would be very helpful to have an option when making a balance query (in tuition) to be able to exclude headchecks payments, otherwise it takes all charges minus all payments including headchecks which im not considering an actual payment all the time.

Answer 1

 

By "payments until" you put a later date so it will not look on head checks 

 

Comments

 And  Val(Format((Select Sum(Amount) From MCharges Where Code = Students.FamilyNum And DueDate <= #10/25/21#  And Company In (1)))) - (Val(Format((Select Sum(Amount) From MPayments Where Code = Students.FamilyNum And Date <= #11/04/21#  And Company In (1)))) )<=50

Its not looking on the check date?