Is there an alternative to using the valuecount to count how many
responses were checked off on a value list? I am using Filemaker pro
5.5 for windows and this function does not seem to be available in that
version.

Thanks,
dan

In article <1131675826.772580.58180 (AT) g44g2000cwa (DOT) googlegroups.com>, "D."
<dtae (AT) yahoo (DOT) com> wrote:

I'm not sure what ValueCount is or does.

If it counts the number of value list items selected in the current
record, then it's really a simply matter of checking if there are no
value chosen or counting the number of Return characters (¶) in the
field and adding one.
ie.
NumChosenOptions {Calculation, Number Result}
= If (IsEmpty(ValueField),
0,
PatternCount(ValueField, "¶") + 1)


More likely you mean counting the number of records that have each
particular value chosen, then this can be done in a few ways, but one
of the simplest is to have a set of fields that you can Sum via a
Summary field or a Relationship (depending on your needs).
ie.
{Calculation fields, Number results}

ChosenValue1 = PatternCount(ValueField, "Value1")

ChosenValue2 = PatternCount(ValueField, "Value2")

ChosenValue3 = PatternCount(ValueField, "Value3")

etc.

Then the number of records with "Value1" chosen is given by:

Sum(ChosenValue1)


OR
if you're already using a separate table / file for you value list
items, then you can set up a relationship link back to the main table /
file and each count is simply:

Count(MainFile::KeyField)



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

I should've thought of that. Thanks Helpful Harry.

..d