The report that I'm developing requires a range of year fields in the page header and detail section, controlled by the user's input. The range of years are never the same. The report must be flexible to handle the various years. Where do I write the code for both the header and detail section to reflect the various years requested by the user in the access form which must be passed to the report ? I will also have to tell it where to put the labels on the page header. The user will input a starting fiscal year and an ending fiscal year; i.e. FY89 - FY91. The report must have a page header and a detail field for each year beginning with 89 thru 93.
Testing Special Problem
ITEM FY Component Qty FY89 FY90 FY91 Total
Radio 9 xx-3010 45 85.00 0.00 100.59 185.59
The next time the report is run the user may want FY 91 - 92. All of the fields are standard except the FY fields.
Testing Special Problem
ITEM FY Component Qty FY89 FY90 FY91 Total
Radio 9 xx-3010 45 85.00 0.00 100.59 185.59
The next time the report is run the user may want FY 91 - 92. All of the fields are standard except the FY fields.