I have a list of names which can be duplicated for example each department takes so many spark plugs and I would like it so there would be a running total where only one department shows up on the list with the summary of how many spark plug of which below is an example.

Department A | Spark Plug A

Department A | Spark Plug B

Department A | Spark Plug A

Department A | Spark Plug B

Department A | Spark Plug B

Department C | Spark Plug A

Department C | Spark Plug A

Department C | Spark Plug A

On the list I would like it to show

Department | Spark Plug A | Spark Plug B

Department A | 2 |3

Department C | 3

Thanks,

Hi, this is a classic case of sub-summaries. Let me assume you are recording "Spark Plug A" or "Spark Plug B" in a field named SparkPlug. In your layout, make a sub-summary part when sorted by Department. Add to that sub-summary part the fields Department, SumSparkA, and SumSparkB.

SumSparkA is a summary field, equal to the sum of IsSparkA.

IsSparkA is a calculated number field, equal to ( SparkPlug = "Spark Plug A" ). (This field will evaluate to 1 whenever the condition is met.)

SumSparkB is a summary field, equal to the sum of IsSparkB.

IsSparkB is a calculated number field, equal to ( SparkPlug = "Spark Plug B" ).

Now, when you sort by Department and print the layout (or go to preview mode), you should see the results you're looking for.

HTH,

Jerry