Calculating Prices * Quantity

[Nanette]

I'm trying to get a Grand Total for multiple pages of a report. I have added
a field control that calculates the Price * Quantity for each row.

How do I get a Grand Total for all Price * Quantities rows and put it on
the last page of the report?

 

[Duane Hookom]

Create a text box in the Report Footer section with a control source like:
=Sum(Price * Quantity)

 

[Nanette]

How do I get a report footer section?

Create a text box in the Report Footer section with a control source like:
=Sum(Price * Quantity)

 

[Larry Linson]

How do I get a report footer section?

Are you just "putting us on"? You didn't open the Report in Design View?
When I do so, I see the lowest bar/band says "Report Footer." If I place my
mouse pointer on the lower edge of that bar, it turns into a vertical
double-headed arrow through a line.. if I hold down the left mouse button
and move the mouse downward, it opens/exposes the Report Footer.

Larry Linson
Microsoft Access MVP

 

[Duane Hookom]

Report header and footer sections sometimes are not displayed. Nanette may
need to select View->Report Header/Footers.