J
jlo
I have a main report that has a subreport. I need the main report to
reference the subreport's average total for each month of the year.
I have all the Avg's figured out in the report footer and they work
correctly. How do I get them on my main report?
I have managed how to get a running total from reading all the forums but
then realized I need the average not a running total. In the main report
when I use the Avg function, it doesn't recognize. Here is an example of
trying to get the March Avg in my main report:
I have a control in the detail section of my main form:
Control Source =[rptAcknowledgementTAT].[Report].[AvgMar]
Name of control = AvgMar
Visible = No
Another control:
Control Source =[AvgMar]
Running Sum = Over All
Visible = No
Name = TotalAvgMar
In my main report footer I have a control:
=[TotalAvgMar]
This works great if I need a running total. How do I get the AvgMar that
exists in my subreport? When I tried another solution, then I only get the
first Avg of the last record in my subreport. Going crazy!
JS
reference the subreport's average total for each month of the year.
I have all the Avg's figured out in the report footer and they work
correctly. How do I get them on my main report?
I have managed how to get a running total from reading all the forums but
then realized I need the average not a running total. In the main report
when I use the Avg function, it doesn't recognize. Here is an example of
trying to get the March Avg in my main report:
I have a control in the detail section of my main form:
Control Source =[rptAcknowledgementTAT].[Report].[AvgMar]
Name of control = AvgMar
Visible = No
Another control:
Control Source =[AvgMar]
Running Sum = Over All
Visible = No
Name = TotalAvgMar
In my main report footer I have a control:
=[TotalAvgMar]
This works great if I need a running total. How do I get the AvgMar that
exists in my subreport? When I tried another solution, then I only get the
first Avg of the last record in my subreport. Going crazy!
JS