Sum up report

M

Michael

When I report in Access I would like for the report to
sum up the items in the report? For ex: on the report I
have 20 differnt part #'s for the month, but I would like
to know how many of each part # we scrapped for the
month. Instead of going through and counting the
manually. How can I make access do this function?
 
C

Chaplain Doug

Use the DCount function as the datasource for a control in
the report footer.

DCount(expr, domain, [criteria])

DCount("[Part#]","Parts","Scrapped=true and DatePart("m",
[PartDate])=themonthyouwant"
 
P

PC Datasheet

Michael,

Create a totals query that counts how many of each part you scrapped then create
a report based on this query and use sorting and grouping to sort on part# or
part name.
 
R

Reggie

Also, if you run the report wizard, as you step through, you can select
grouping options and whether or not to perform totals based on the groupings
you've selected and/or create running sum's over all the groups etc. I'm not
real ken on the finished reports created by the wizards, but you can view
them in design and either modify them to your liking or simply view how it
is accomplished.
 
Top