Embedded Subforms causing me grief....

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

Guest

I have a main report (w/ no record source)…two sub-reports embedded into the
main report. Each of the sub-reports is based on a query (identical queries
w/ exception of the sorts…one sorts for Completed Suicides & the other sorts
on Attempted Suicides).

Hence, my Main Metrics Report returns the results for both Attempts &
Completions and the respective metrics.

That being said, each query has the following criteria for the “Date of
Incident†: Between [Enter Start Date] and [Enter End Date].

Question: is there a better way to do this so I don’t have to enter the
Start and Enter dates for each sub-report? Is there a way to tie it into the
main report where I only have to enter the Start & End Dates once?

Thanks in advance for your help.

V/R,

Steve
 
Shek5150 said:
I have a main report (w/ no record source)…two sub-reports embedded into the
main report. Each of the sub-reports is based on a query (identical queries
w/ exception of the sorts…one sorts for Completed Suicides & the other sorts
on Attempted Suicides).

Hence, my Main Metrics Report returns the results for both Attempts &
Completions and the respective metrics.

That being said, each query has the following criteria for the “Date of
Incident” : Between [Enter Start Date] and [Enter End Date].

Question: is there a better way to do this so I don’t have to enter the
Start and Enter dates for each sub-report? Is there a way to tie it into the
main report where I only have to enter the Start & End Dates once?
Click to expand...


Use a form with text boxes for the start and end dates along
with a button to open the report. Then the query's criteria
would be like:
Forms!theform.txtStart
instead of [Enter Start Date]
 
Back
Top