Sum in a report

[Guest]

I have a report based on a parameter query.

The report looks somewhat like this:
Name Color Quantity Value Total
Wine1 Red 2 $10 $20
Wine2 White 3 $20 $60
Wine3 Rose 1 $15 $15

The parameter from the query is color
The value is =[Quantity]*[Value]

In the report footer, I have a text box with =[Total]

Although the total in this text box should show $95, it shows $15, which is
the last entry in my report.

Can anyone please help me, I am probably just missing a very simple thing here
Thanks
Jeannie

 

[Guest]

The Sum in the Report Footer need to include the formula and not the text box

Try:
=Sum([Quantity]*[Value])

 

[Guest]

Thank you so very much
I added a sum for value (non visible) in the report footer and entered your
formula in my unbound text box and I got the right total.
Much appreciated
Jeannie

The Sum in the Report Footer need to include the formula and not the text box

Try:
=Sum([Quantity]*[Value])


--
Good Luck
BS"D

I have a report based on a parameter query.

The report looks somewhat like this:
Name Color Quantity Value Total
Wine1 Red 2 $10 $20
Wine2 White 3 $20 $60
Wine3 Rose 1 $15 $15

The parameter from the query is color
The value is =[Quantity]*[Value]

In the report footer, I have a text box with =[Total]

Although the total in this text box should show $95, it shows $15, which is
the last entry in my report.

Can anyone please help me, I am probably just missing a very simple thing here
Thanks
Jeannie