subtraction & addition from subreports in a report

[Guest]

Hi,

I have had to import a few subreports (which include queries) into a larger
report. I then want to add or subtract the number in the main report. Imagine
for example I have the total number of projects worked on in a year and
another subreport had the answer, what I need in the middle is the third
variable to get from the start to the finish.

I tried doing this in a query, but it didn't like me taking one query away
from another.

Please advise, or let me know if you need further information.

Many thanks

F0zz

 

[Allen Browne]

See:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

If you are then trying to accumulate the total from the various instances of
the subreport throughout the main report (assuming it has several related
records where the subreport shows up), you will need to use a Running Sum
text box to do that:

Assuming that the text box shows the total from the subreport is named
txtSubTotal, add another text box to the same section of the report, and
give it these properties:
Control Source =[txtSubTotal]
Running Sum Over All
Visible No
Name txtSubTotalRS

Now add another text box to the Report Footer section, and set its Control
Source to:
=[txtSubTotalRS]