SubReport Calculation

T

tiyago

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
 
D

Duane Hookom

There are no columns and rows in Access. You need to define your
requirements in terms of data values saved in tables.
 
T

tiyago

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,
 
D

Duane Hookom

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
 
Top