Been looking through various posts and feel sure this can be done, I have partially done it using PrevRecVal module I found on the web.
I created what I need to do in Access in Excel first, the problem doing this in Access (for me) is I need to refer to the results in the previous record, PrevRecVal helped but I need help to finish if possible.
The main report holds client policy data of which InvestAmount is used to start the calculation of the sub report, the data entered to run the calculations on the subreport would be
QtrDate
CurrentUnitPrice
the Excel spreadsheet is attached which may help explain what I'm trying to do.
Any help with this would be greatly appreciated
thanks
Fi
I created what I need to do in Access in Excel first, the problem doing this in Access (for me) is I need to refer to the results in the previous record, PrevRecVal helped but I need help to finish if possible.
The main report holds client policy data of which InvestAmount is used to start the calculation of the sub report, the data entered to run the calculations on the subreport would be
QtrDate
CurrentUnitPrice
the Excel spreadsheet is attached which may help explain what I'm trying to do.
Any help with this would be greatly appreciated
thanks
Fi