I have many reports in my database that are selected according to the month and year. I have used different criteria in setting up the selection processes for the user, such as date dialog boxes splitting the month and year and 'from and to' selections. I would like to standardize the selection by making a standard drop-down list box (which I can then apply to the on-open event of a report). When a user selected a certain report to preview or print, this selection box would then be called and the user can just highlight the given month and year and the report will be generated based on their selection.
Example:
January 1999
February 1999
March 1999, and so on
My problem: is this feasible given the amount of reports and the selection criteria?
Could this standard form be applied as my criteria base for the underlying queries on the report?
Would all the date fields and layouts within the associated reports have to be standardized to the same format?
Any help given would be appreciated.
Example:
January 1999
February 1999
March 1999, and so on
My problem: is this feasible given the amount of reports and the selection criteria?
Could this standard form be applied as my criteria base for the underlying queries on the report?
Would all the date fields and layouts within the associated reports have to be standardized to the same format?
Any help given would be appreciated.