FMPRO-L Archives

May 2012, Week 2

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
John Montana <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Mon, 14 May 2012 09:54:14 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (22 lines)
Hi All,

I have a field with check boxes, 24 values.

I count the checked values per record with the ValueCount() function. Works great.

Now I need a way to know how many checked boxes per record in a found set.

Example.

Record 1 - 5, 3 boxes checked
Record 6, 4 boxes checked
Record 7 - 12, 6 boxes checked

Result:

5 records with 3 boxes checked
1 record with 4 boxes checked
6 records with 6 boxes checked

Any hint how to start ?

ATOM RSS1 RSS2