Total items in Report, Sort by different column

[Kevin]

I have a query that shows material in one column, and the P.O number in one
column, and the price per item in one column. Multiple items can be assigned
to one PO number. What I need to do in the report is sort the info by PO,
then show the total per PO at the bottom of the material listing. I know this
will have to be done in a footer, but I dont know how to create the formula.
Ex:
PO Material Price
001 Widgets 10.00
001 connectors 15.00
Total This PO 25.00

002 Straws 3.00
002 Cups 4.50
Total this PO 7.50

Thanks

 

[Lance]

In the group footer do a =sum([Price])

 

[Fred's]

In the group footer do a =sum([Price])

I have a query that shows material in one column, and the P.O number in one
column, and the price per item in one column. Multiple items can be assigned
to one PO number. What I need to do in the report is sort the info by PO,
then show the total per PO at the bottom of the material listing. I know this
will have to be done in a footer, but I dont know how to create the formula.
Ex:
PO Material Price
001 Widgets 10.00
001 connectors 15.00
Total This PO 25.00

002 Straws 3.00
002 Cups 4.50
Total this PO 7.50

Thanks- Hide quoted text -

- Show quoted text -

Hi Lance,

Me, I have the text box name "Chaussures" that have this formula:
=Sum([CHAUSSURES])+([ALDO])+([Feet-First])+([Transit])+([Globo]).

For example:

ALDO -> 5 units
Feet-First -> 10 units
Transit - 10 units
Globo - 10 units

My sum in my text box "Chaussures" gives a sum of 35.

now, how Can I make grand total from all record lines "chaussures" in
the report footer?