Formulas

[Daniel Biancuzzo]

In the detail section of a report I have designed, I have a text box with
the formula "=[QNTY]*[PRICE]" in a column with the heading "SUBTOTAL"
defined in the page header of the report. The text box with the formula is
"Text36". So in the report footer I am trying to insert a formula in
another text box to do the overall total by using
"=Sum(Reports![Reportname]![Text36]).

The formula in the text box within the report detail section works fine,
however the overall total in the report footer shows up blank. Does anyone
know what I am doing wrong?

 

[Joseph Meehan]

In the detail section of a report I have designed, I have a text box
with the formula "=[QNTY]*[PRICE]" in a column with the heading
"SUBTOTAL" defined in the page header of the report. The text box
with the formula is "Text36". So in the report footer I am trying to
insert a formula in another text box to do the overall total by using
"=Sum(Reports![Reportname]![Text36]).

The formula in the text box within the report detail section works
fine, however the overall total in the report footer shows up blank.
Does anyone know what I am doing wrong?

Add a textbox Text37 right next to Text36" (you can even copy and past
it) then set its properties to sum over all. Then reference it in the
footer.

 

[Cheryl]

Try just doing "=sum([qnty]*[price])"?

Depending of course,on how you have your report query
written and what you have happening with your Sorting and
Grouping.

 

[Mike Painter]

In the detail section of a report I have designed, I have a text box with
the formula "=[QNTY]*[PRICE]" in a column with the heading "SUBTOTAL"
defined in the page header of the report. The text box with the formula is
"Text36". So in the report footer I am trying to insert a formula in
another text box to do the overall total by using
"=Sum(Reports![Reportname]![Text36]).

The formula in the text box within the report detail section works fine,
however the overall total in the report footer shows up blank. Does anyone
know what I am doing wrong?

"=Sum([QNTY]*[PRICE])" in the footer.
Access is pretty smart about knowing what you want to do but tends not to
like summing items defined in the report itself.

If SubTotal is defined in the query used for the report sum(SubTotal)
should work fine.