inconsistant result in group footer

[Guest]

I have a report with a subform with a group footer. In the group footer I
have a calculated field with this expression in the control source:

=Sum(Nz([quantity],0)*Nz([unit_price],0))

Quantity and unit_price are both fields in the table to which is the record
source for the subform. When I run the report it works perfectly. When one
of my users runs the report, she gets #error. I have given her all the
permissions for the report and the underlying tables. I don't know where to
look next to explain this. Can anyone give me a suggestion?

 

[Guest]

If you are summing the values in a subreport, the subreport is the place to
do it.

You can always reference that control in your main form. Doing it this way
will allow you to sum the values from multiple subreports if you ever have a
need for that.

So place the calculated control in the subreport's footer. Then reference
that control in your main report - Me!MySubReport.MyControl

Steve

 

[Guest]

I didn't describe the problem properly, but your answer may have helped me
find a solution anyway. The total that didn't work was in the page footer,
and it referred to a subform rather than a subreport - I am hoping that
fixing this will solve the problem.

Thanks for answering!

If you are summing the values in a subreport, the subreport is the place to
do it.

You can always reference that control in your main form. Doing it this way
will allow you to sum the values from multiple subreports if you ever have a
need for that.

So place the calculated control in the subreport's footer. Then reference
that control in your main report - Me!MySubReport.MyControl

Steve

I have a report with a subform with a group footer. In the group footer I
have a calculated field with this expression in the control source:

=Sum(Nz([quantity],0)*Nz([unit_price],0))

Quantity and unit_price are both fields in the table to which is the record
source for the subform. When I run the report it works perfectly. When one
of my users runs the report, she gets #error. I have given her all the
permissions for the report and the underlying tables. I don't know where to
look next to explain this. Can anyone give me a suggestion?