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
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …