Beginning Balance
Experts,
I have an issue trying to get a Beginning Balance.
Beginning Balance = tblFacility.Commitments.Fa
but for the first record the balance must be just the tblFacility.Commitments.Fa
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
I have an issue trying to get a Beginning Balance.
Beginning Balance = tblFacility.Commitments.Fa
but for the first record the balance must be just the tblFacility.Commitments.Fa
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you ALS. I suppose I shall split the points if there is no objection. Anything else to add let me know. thank you again....
OK, split points
ASKER
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.