Promting, Forms or connect reports?

[Jake F]

I have a report which totals differents tests and program statuses of herds.
I had to put 6 querries into 6 subreports of the main report to keep the
datasets distinct. All of them have prompts for a date range and all the
date ranges are the same so I have to enter the same dates multiple times.
Is there a way I can connect the reports so that they just connect to the
dates or if i could somehow use a form? Any help would be great. Thanks.

 

[Marshall Barton]

I have a report which totals differents tests and program statuses of herds.
I had to put 6 querries into 6 subreports of the main report to keep the
datasets distinct. All of them have prompts for a date range and all the
date ranges are the same so I have to enter the same dates multiple times.
Is there a way I can connect the reports so that they just connect to the
dates or if i could somehow use a form?

Yes, use a form. Add unbound text box's for the date range
and use a button to open the report.

Then change the queries to use criteria like:
Forms!theform.thestartdatetextbox
instead of [Enter strat date]

 

[Jake F]

Thank you! That made my report a million times better and I don't have to
worry about entering the wrong date range in.

I have a report which totals differents tests and program statuses of herds.
I had to put 6 querries into 6 subreports of the main report to keep the
datasets distinct. All of them have prompts for a date range and all the
date ranges are the same so I have to enter the same dates multiple times.
Is there a way I can connect the reports so that they just connect to the
dates or if i could somehow use a form?

Yes, use a form. Add unbound text box's for the date range
and use a button to open the report.

Then change the queries to use criteria like:
Forms!theform.thestartdatetextbox
instead of [Enter strat date]