Totals of each different value (totals based on name)

[iProRyan]

Hi Guys



I have a report that shows each Job and the Parts attached to it. What I'm trying to do is total up each different name of part so at the bottom I can have a total that looks like

PartA - 10
PartB - 2

For each record on the report their is the JobID it relates to, the name of the part and the quantity for that job, basically how can I total based on the name?

Ryan

[ItsMe]

If you are not grouping by part A and Part B, etc. I would use VBA to do the calculations.

[June7]

Use report Grouping and Sorting feature.

[Xipooo]

Hi Guys

I have a report that shows each Job and the Parts attached to it. What I'm trying to do is total up each different name of part so at the bottom I can have a total that looks like

PartA - 10
PartB - 2

For each record on the report their is the JobID it relates to, the name of the part and the quantity for that job, basically how can I total based on the name?

Ryan

Here is a video on grouping and sorting reports. http://www.youtube.com/watch?v=uVHez5A6v0I