fiscal year

[Vivian]

Is there a way I can produce a summary report with
multiple subreports for a fiscal year other than a
calendar year - without having to enter start and stop
dates for each underlying query?
TIA
Vivian

 

[Bruce M. Thompson]

Is there a way I can produce a summary report with

multiple subreports for a fiscal year other than a
calendar year - without having to enter start and stop
dates for each underlying query?

Consider generating a "lookup" table including a field for the "fiscal year" and
fields containing the starting and ending dates for each. If you have a form
that is used for accessing such reports, you can implement a combo or list box
based on that table for fiscal year selection and have the reports'
recordsources retrieve the criteria values from either the combo/listbox or, if
you prefer, textboxes (either visible or hidden) that can be filled with the
related date values upon selecting a value from the combo/listbox.

 

[John Vinson]

Is there a way I can produce a summary report with
multiple subreports for a fiscal year other than a
calendar year - without having to enter start and stop
dates for each underlying query?

One trick that can help is to use a calculated fictitious date.
Suppose the FY starts April 1; January 2003 is in FY 2002, June is in
FY 2003. You can get this effect by including a datefield

FiscalDate: DateAdd("m", -4, [datefield])

and/or

FiscalYear: Year(DateAdd("m", -4, [datefield]))