Count of summary field

[jeffmcg]

I have a report with subsummaries. I want to count the number of subsummaries.

Example

Cars 7

" "Green 4

" "Red 1

" "Blue 2

I want to get a count of the different colors, in this case 3 different colors.

Edited March 30, 2007 by Guest

[mr_vodka]

First it seems as though you want a sum of the amounts, not a count. If you have a summary field with sum and then you put it on the grouped subsummary part, it will give you the total grouped.

Edited March 30, 2007 by Guest

[jeffmcg]

I don't want the number of cars, I want the number of different colors

[jeffmcg]

i have a self join relationship that identifies unique colors.

I can find unique colors

I can get found count of unique colors

I can set field to hold the value of count of colors

I can insert field on my report layout but it is only visible in browse not preview.

This seems like a lot to do just to get a count of the unique colors.

[hunter]

Hi,

I am afraid I don't have an answer. I have the same problem.

I want a count of the summaries, not all the records.

I have a child table with records showing multiple contacts. I need a count of the contacts, but only count 1 for each unique contact.

I summarize by contact, and I can get 1 count per the subsummary, but I cannot get a grand total that returns the total of the 1 count per each subsummary. I get the count of all records. I've tried quite a few different calculations, but haven't hit on it yet.

Anyone have an simple solution? I've read about exporting the summaries, but is there a simpler way to get this result without scripting an export?

Thanks,

Lesley

[comment]

See if this helps.

[hunter]

Thank You! Yes, it worked great for the grand total. I was headed in a much more complicated route.

:laugh2: