FMPRO-L Archives

May 2012, Week 2

FMPRO-L@LISTSERV.DARTMOUTH.EDU

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

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

Print Reply
Mime-Version:
1.0
Content-Type:
text/plain; charset="UTF-8"
Date:
Mon, 14 May 2012 09:54:14 -0400
Reply-To:
FileMaker Pro Discussions <[log in to unmask]>
Subject:
Content-Transfer-Encoding:
quoted-printable
Message-ID:
Sender:
FileMaker Pro Discussions <[log in to unmask]>
From:
John Montana <[log in to unmask]>
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