asked on 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
Microsoft Access
Last Comment
als315
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
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.