Promting, Forms or connect reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Jake said:
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?
Click to expand...

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]
 
Thank you! That made my report a million times better and I don't have to
worry about entering the wrong date range in.

Marshall Barton said:
Jake said:
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?
Click to expand...

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]
Click to expand...
 
Back
Top