I have a report which shows a summary of current month's inventory and transactions.I need to roll the previous ACTUAL BALANCE into the next month's report which will become the new month's BEGIN BALANCE. These numbers do not appear to be updating..
Hoping someone can point me in the right direction.
Sample DB attached. The query for the report is based on qryRSumMTD2Transactions.
You can use the report builder form called frmReportBuildSumMTD
Use dates 4/1/21 to 4/30/21 and 5/1/1 to 5/1/21 (or 5/1/1 to 5/11/21)
Hoping someone can point me in the right direction.
Sample DB attached. The query for the report is based on qryRSumMTD2Transactions.
You can use the report builder form called frmReportBuildSumMTD
Use dates 4/1/21 to 4/30/21 and 5/1/1 to 5/1/21 (or 5/1/1 to 5/11/21)