Carry forward value in Access Report
Posted on 2010-09-03
I have an Access 2003 report I need some advice with
This report has a group section of fiscal years.
There is an unbound control in this section called Base
Initially the first Base value is a value from an underlying query which I use code to fill in ...no problem
Following years is other data for the same fiscal year coming from a subreport with a total called PermTotal..again no problem
Heres where the problem is.
For Subsequent years the next Base should be the previous Base with the PermTotal for this current year.
I have code which has a variable to hold the previous base amount.
and then add in the subreport values for this current year.
I think part of my problem is that my code is in the group section for the fiscal years. It fires when I advance the pages.
Though the stored previous base is available, the subreport values dont appear to be ready yet...so they are 0 resulting in the wrong total
I appreciate the help