Sum up report

  • Thread starter Thread starter Michael
  • Start date Start date
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?
 
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"
 
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.
 
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.
 
Back
Top