counting in report

[michellerobinso]

ive created a report

the fields in the report are

manufacture
part code
fault code
qty

i would like to add up the total qty for each manufacture but i dont know how to do this.

can anyone help?

 

[Pat Hartman]

With the report in design view, open the sorting/grouping dialog and add a group level for manufacturer and also a header and footer. In the header, place the control for the manufacturer's name. In the footer, add an unbound control to sum the quantities. Its ControlSource should be:

=Sum(qty)

BTW - it is poor practice to use spaces or special characters in column names. Also make sure you avoid using function names such as Date and Month and avoid property names especially Name since .Name is a property of almost every database object.