Report/Subreport totals

[Scott Sabo]

I have read many threads on this and just cannot figure it out. I have
a sub report named srptSOPItems. The sub report has a calculated
control in the subreport footer named txtSOPTotals. The control source
for this field is =SUM([SOPExtPrice]). This report is used to get the
information related to Special order products on a quote sheet (the
main report).
On the main report, rptQuoteTest, I have a control named QuoteTotal
with a control source of =Sum([ExtPrice]).
On both report, when run independantly, the total sections are
correct. I cannot get the coding right to add a text box to the main
reports footer to give me the sum of the subreport's total plus the
main reports total. I have tried to mimic examples on different posts
and most of the time (99%), I go to preview my main report and I get
prompted by a dialog box which refences some part of the calculation I
used in the main report footer control to summarize both of the totals
(the dialog box looks like a parameter box like if you needed to enter
dates). I hope sombody can point me in the right direction, I always
toil to figure things out on my own, but this one has me at a loss.
Thanks in advance.

Scott

 

[Jeff Boyce]

Scott

What expression are you using for the Control Source (or Value) of that
added text box? Are you using a procedure to do the calculation? What
event, in which report (main, sub) are you using as a trigger?

 

[Scott Sabo]

Scott

What expression are you using for the Control Source (or Value) of that
added text box? Are you using a procedure to do the calculation? What
event, in which report (main, sub) are you using as a trigger?

Jeff-
I will try to answer as best I can. I don't think I have any
procedures or events being called regarding this question. I was
adding a text boxt to the footer of the main report and trying to
refernce both the main report totals control and the subreport totals
control to add them both together. Like I said, I tried to copy
various formats from other post but nothing worked. I dont have my
database available (posting from work), but it would be something like
=([srptSOPItems].Reports.![stxtSOPTotals]+[rptQuoteTest].[QuoteTotal])
I am probably way off and really don't know where I have it wrong. Do
the reports need to be linked (the sub and main)? When it pops up the
dialog box once I try to preview, it looks like the main report is
telling me it does not understand what information I am looking for in
the subreport. That is why I thought it was a linking issue. I am just
starting in Access 2003 and could not even find out where parent/child
links are created anymore. Please help.....