Background: I manage the commercials of a large engineering project from an Access database. I run a significant number of resource cost and budget reports regularly over the course of the fiscal year. At the end of the year, the database is archived, and I create a new database. In the new database the reports need to be revised to include the new year's parameters: viz Fiscal Year, number of weeks in each fiscal month, etc. So far I have been manually editing the reports, but this is tedious due to the number of reports and the number of calculated controls on each report.
Question: what is the best way to pass fixed data such as Fiscal Year, Fiscal Month Start and End dates, etc. to a control on a report so that I don't need to edit so many different controls? I tried using Global Constants, but this only works if I create a dummy control that gets assigned its value via the report's On Open event VBA routine, then reference the dummy control in a control's formula elsewhere on the report. There must be a better way!