I have a pretty simple database that I'm using to record petty cash transactions. I have a form filtering the report based on whatever date range is selected, but what I need is for my report to display a balance forward amount and then perform the simple calculations off of that value.
My db is set up as
TblClients:
ClientID
FirstName
LastNAme
TblPettyCashTransactions:
ClientId
DepositAmount
WithdrawlAmount
TransactionDescription
I have my report filtered by date values, what i need is somehow look up and Sum([DepositAmount])+Sum([WithdrawlAmount]) from Transactions Table based on the ClientId in the group and with dates < the first record of the grouping.
If you need any more help understanding I can upload a stripped down DB for you to examine. I really appreciate your help, I'm fairly new at this and hopefully I can learn a bit more from the experts. Thanks in advance!