There's that elegant solution I was alluding to!

The problem might be that that would be a whole buncha sub summary parts. ("110+" he says.)

j.


On May 14, 2012, at 12:30 PM, Steve Cassidy wrote:

> 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


--
Jonathan Fletcher
FileMaker 9/10/11 Certified Developer

Fletcher Data Consulting
[log in to unmask]
http://www.fletcherdata.com
502-509-7137

Personal Blog o'Stuff: http://jfletch.posterous.com

Kentuckiana's FileMaker Users Group
Next up: Build-from-scratch and more Twelve!
Tuesday, May 22, 12:00 pm to 3:30-ish
Blog: http://www.kyfmp.com