I have a Value List of services provided that is assigned to a Field, set up
as checkboxes. Multiple items can be checked.

Is there a way I can run a report that will tell me a total number of times
each item in the Value List has been checked.

I've tried some summary fields, but the subsequent report just list the
first item, not each separate.

Steve McGillivray
Arizona State University

In article <BF0423B2.31BD%steve.mcgillivray (AT) asu (DOT) edu>, Public Affairs
<steve.mcgillivray (AT) asu (DOT) edu> wrote:

Basically there's two methods to solve this. Which one you choose may
depend on whether all the data has already been entered or not (and if
it has, whether you want to spend time re-purposing it all).

For example, if you have a Value List of:

Bugs Bunny
Papa Smurf
Yogi Bear

then the two basic methods are ...



METHOD A
You can make each Checkbox item a separate field with it's own
single-item Value List:

BugsBunny Value List = "Bugs Bunny"

PapaSmurf Value List = "Papa Smurf"

YogiBear Value List = "Yogi Bear"

This means you can then summarise each option via separate Summary
fields using Count option.
ie.
s_BugsBunny Count of BugsBunny

s_PapaSmurf Count of PapaSmurf

s_YogiBear Count of YogiBear





METHOD B
You can create some three new Calculation fields which are used to
tally the Checkboxes replies:

BugsBunnyYes = If(PatternCount(CheckBoxField, "Bugs Bunny", 1, 0)

PapaSmurfYes = If(PatternCount(CheckBoxField, "PapaSmurf", 1, 0)

YogiBearYes = If(PatternCount(CheckBoxField, "Yogi Bear", 1, 0)

These fields can then be summarised separately via a Summary field
using the Total option.
ie.
s_BugsBunny Total of BugsBunnyYes

s_PapSmurf Total of PapaSmurfYes

s_YogiBear Total of YogiBearYes




The only real difference between the two methods is that Method B
retains the original single Checkbox field and single Value List, which
may be useful for reports where you want just a list of the checked
values (although you can still do this in Method A by using the
separate fields and the Sliding option to remove blank fields from the
printout).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)