Formulas

  • Thread starter Thread starter Daniel Biancuzzo
  • Start date Start date
D

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?
 
Daniel said:
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?
Click to expand...

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.
 
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.
 
Daniel Biancuzzo said:
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?
Click to expand...
"=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.
 
Back
Top