J
Jen W
I have a main report with 3 subreports and I want to add all subtotals
together at the bottom of my main report.
together at the bottom of my main report.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
their values come from, we can only guess.
J
Jen W
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
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
D
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
--
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
--
Jen W said: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 said:What "all subtotals"? If you don't tell us where these are located and
where
their values come from, we can only guess.
J
Jen W
Thanks so much. I got it to work.
Jen
Jen
Duane Hookom said: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
--
Jen W said: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 said:What "all subtotals"? If you don't tell us where these are located and
where
their values come from, we can only guess.