I need to take yesterdays pending balance and add it to todays avail to process-todays processed. For example:
Date: 11/19 Pending= 563
Date: 11/20 Aval to Process= 78; Processed=235
Add: 563 (from yesterday) +78=641- 235 (processed 11/20)= 406 Pending. I have two linked queries that generate the report. But, I can't figure out how to get the Pending balance from yesterday. Can someone help. I am not a programmer so I don't understand Visual Basic. I do everything in a table/form/query/report and I do use limited macros.
Date: 11/19 Pending= 563
Date: 11/20 Aval to Process= 78; Processed=235
Add: 563 (from yesterday) +78=641- 235 (processed 11/20)= 406 Pending. I have two linked queries that generate the report. But, I can't figure out how to get the Pending balance from yesterday. Can someone help. I am not a programmer so I don't understand Visual Basic. I do everything in a table/form/query/report and I do use limited macros.