how do I add subtotals from multiple subreports on my main report

[Guest]

I have a main report with 3 subreports and I want to add all subtotals
together at the bottom of my main report.

 

[Duane Hookom]

What "all subtotals"? If you don't tell us where these are located and where
their values come from, we can only guess.

 

[Guest]

Sorry- I'm a firstimer on here.
I meant I need to add a subtotal from each subreport onto my main report. I
tried this
+special ed query.form![TEXT23]+other query.form![TEXT20]+poverty
query.form![PWGT]
where special ed query is the name of the subreport and the field TEXT23 is
the field that sums the values in the subreport.

Jen

 

[Duane Hookom]

First off, find and use a good naming convention. If you plan to reference a
text box anywhere else, you should really give it a proper name.

Also, are you using a form as a subreport?

Generically to reference the value of a control on a subreport from a main
report, use:
=[subreportControlName].Report!txtNameOfControlOnSubreport

If you have spaces in object names (not a good thing), you must surround
your object names with [ ]s.

--
Duane Hookom
MS Access MVP
--

Sorry- I'm a firstimer on here.
I meant I need to add a subtotal from each subreport onto my main report.
I
tried this
+special ed query.form![TEXT23]+other query.form![TEXT20]+poverty
query.form![PWGT]
where special ed query is the name of the subreport and the field TEXT23
is
the field that sums the values in the subreport.

Jen

What "all subtotals"? If you don't tell us where these are located and
where
their values come from, we can only guess.

 

[Guest]

Thanks so much. I got it to work.
Jen

First off, find and use a good naming convention. If you plan to reference a
text box anywhere else, you should really give it a proper name.

Also, are you using a form as a subreport?

Generically to reference the value of a control on a subreport from a main
report, use:
=[subreportControlName].Report!txtNameOfControlOnSubreport

If you have spaces in object names (not a good thing), you must surround
your object names with [ ]s.

--
Duane Hookom
MS Access MVP
--

Sorry- I'm a firstimer on here.
I meant I need to add a subtotal from each subreport onto my main report.
I
tried this
+special ed query.form![TEXT23]+other query.form![TEXT20]+poverty
query.form![PWGT]
where special ed query is the name of the subreport and the field TEXT23
is
the field that sums the values in the subreport.

Jen

What "all subtotals"? If you don't tell us where these are located and
where
their values come from, we can only guess.