Report Totals

[Guest]

I have a report, based on a query. In the report I have a calculation in an
unbound textbox where I multiply the Standard Cost by the Safety Stock
quantity of a number of items in order to get the value of each item.
The control source for the equation reads as “=[SafeStk]*[StdCost]â€.
I have named the unbound textbox as SSCurValue.

I want to have a total for all the items. In the Report Footer section I
placed the following equation in an unbound textbox:
=sum([SSCurValue]) but his results in an error message saying “The Microsoft
Jet database engine does not recognize “[SSCurValue]†as a valid field name
or expression.

Does this mean that I need to perform the equation in the query first so
that it is then an “expression�
And if that is the case, does it mean that any equations created in a report
can not be totaled?

 

[Chris Reveille]

You can't sum a calculated total in a report. do the first
calculation in a new field in the query. Display it in the
report and sum that field.

Or

for your total use
sum([standard cost] * [safety stock])

Chris