I have an issue trying to get a Beginning Balance.
Beginning Balance = tblFacility.Commitments.FacilityAmount - Q_Disbursement.SumOfAmount
but for the first record the balance must be just the tblFacility.Commitments.FacilityAmount
I cant seem to get the balance correct.
You can see my Q_Available in the attached. I am way off and dont understand why.
Grateful for some help. BalanceEE.accdb
Glad to see your response. I was actually looking at another question you had answered for me awhile ago and was similar. I cant quite follow the queries and apply it to a different situation. here is the question: https://www.experts-exchange.com/questions/28584650/Fee-calculation-DAY-COUNT.html
anyways, back to some sample data. I should have included some...sorry. Please see attached and screen print of the attachment. I hope my data is clear as to what I need. Let me know if you need some more details. I think my approach now is just to have a balance. Thank you for your patience.