Using 2 sum fields as the basis for a 3rd calculation returns no result

[Maja]

I'm using 2 sum fields in the footer (one is: =Sum([B&P Actual Cost]) and the other is: =Sum([Total Value]) to generate a third equation: =Sum([AccessTotalsB&P Actual Cost]/[AccessTotalsTotal Value]).

The third equation is not showing anything on the report, but I don't have an error message. However, when I switch views, the system asks me to enter the parameter values for AccessTotalsB&P Actual Cost and for AccessTotalsTotal Value.

How do I fix this (get rid of the parameter requests and get the results of the 3rd equation to show up on the report)?

Appreciate any help you can give.

Maja

 

[boblarson]

You can't do it that way in a report. You have to use the entire calculation (also make sure no control names are named the same as your fields from your recordsource).

so for the third you would need:

=Sum([B&P Actual Cost])/Sum([Total Value])

 

[Maja]

Bob:

Thank you so much!! Works just perfectly now