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

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])

Bob:

Thank you so much!! Works just perfectly now :)