On 14 May 2012, at 15:29, Jonathan Fletcher wrote:

> Sorry. Answered too fast. That was wrong.

Jonathan

Was it so wrong?

I think John could add a new field to each record as you suggested: boxCount = ValueCount ( chckBoxField )

Then add another calculated field to use as a counter: unity = 1

Plus a summary field to add up the counters: sum = sum (unity)

Use a layout with only a subsummary part set as "when sorted by boxCount". On the subsummary part you can use merge fields, I believe, like:

<<sum>> records with << boxCount >> boxes checked

Make sure your found set is sorted by boxCount and that should be it.

Untested!

Steve