Y
Yeahyeahyeah
I have a report based on a table of data detailing incident reports from my
agency. This report is generated from a series of queries that isolates data
to compare quarter to quarter totals.
Here’s the issue: the final report is generated through a series of 6 or so
queries each of which has date-limiting expressions in the criteria field.
Some of them limit the quarter in question , some the previous quarter and
some from the same quarter a year ago. Each quarter when I run the report I
have to go into each of the queries and enter the new dates manually.
Could anyone give me a broad overview as to how I could create a form that
could ask for quarter under consideration and calculate the necessary date
ranges to create the report without having to manually change the queries.
Thanks for the help,
David
agency. This report is generated from a series of queries that isolates data
to compare quarter to quarter totals.
Here’s the issue: the final report is generated through a series of 6 or so
queries each of which has date-limiting expressions in the criteria field.
Some of them limit the quarter in question , some the previous quarter and
some from the same quarter a year ago. Each quarter when I run the report I
have to go into each of the queries and enter the new dates manually.
Could anyone give me a broad overview as to how I could create a form that
could ask for quarter under consideration and calculate the necessary date
ranges to create the report without having to manually change the queries.
Thanks for the help,
David