Need some help with totals on report

[chiefeag]

I have a report that is showing all Purchse orders for a particular customer. This report my contain several or many PO's that are sorted that way and I want to total the value of each PO within the report.

I can sum all the values at the end of the report but how do I total the value for each PO on the report instead of a total at the end.

 

[bjackson]

add grouping to the report with a group header and footer and
sum the values of the group in the group footer,similiar to what you are doing in the report footer

group your reports on PO

 

[chiefeag]

Okay how do I do that

Thanks for the response, I appreciate it.

Where would I go to find out about grouping and how to add that.

Scott

 

[bjackson]

in design view of your report select
1.view
2.sorting and grouping

in there you can select what field to group on,group header or group footer etc

the built in access help files is a good source of help for just about everything in access

 

[Rich]

If you use the Wizard to build the Report it'll add the Group/Grouping levels etc for you