View Single Post
  #2  
Old September 21st, 2004, 02:21 AM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

wrote:

I have a report/sub report. I would like to add the sum
of the report and the sub report and display it on the
report. Is this possible? If yes, how?


Does the subreport appear more than once (e.g. in each
detail)?

If not, then you can use a text box with a simple expression
like:
=Sum(field) + subreport.Report.textbox

field
is the name of the field in the main report's record source
table/query that you want to sum.

subreport
is the name of the subreport control on the main report.

textbox
is the name of the text box in the subreport's footer that
you want to add to the main report's total.
--
Marsh
MVP [MS Access]