SubReport Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Report that contains two (2) Sub-Reports. The Sub-Reports contain
the same number of rows and columns. I would like to calculate, for example,
SubReport1Column3Row2/SubReport2Column3Row2 and to display it on the main
report.

Please advise
 
There are no columns and rows in Access. You need to define your
requirements in terms of data values saved in tables.
 
Thanks for the info.
Let me rephrase my question.

My Sub-Reports have the same structure: Job#, Account#, Jan,.. Dec.
The Sub-Reports are liked to the main report by Job#.
I need to calculate, for example, Sub-Report1-Account#2-May /
Sub-Report2-Account#2-May on a filed in the main report.

thanks,
 
If I told you how to calculate this for May, would you follow up with a
question for a different month? You can create a text box in the report
footer of each subreport like:

Name: txtAcct2May
Control Source: =Sum(Abs([Account]="Account 2") * [May])

Create this in each subreport and then add a text box on the main report:
=subrpt1.Report.txtAcct2May + subrpt2.Report.txtAcct2May
 
Back
Top