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