Very Computer

I have a fields that has optional text results via checkboxes.  I need a total
count  of number of responses for each possible entry to show on the summary
report.

Also - I have four different responses possible in a single text field.  How do
I count the total for each response. I found a cumbersome solution for this by
creating a holding field HOLDING = If (Field ="Yes", 1,0) and then creating
counting fields for Yes, No and N/A (no entry/no response).  This gets more
complicated when you have more possible unique text.

Isn't there an easier, more elegant way to do this? I have no problem changing
the structure of the database - as I have not entered much data until I get the
layouts and reports the way I want them.

Thanks for any help with this.

Erika

It is not entirely clear from your post whether you want to count the
number of responses in a check box field or whether you want to count the
numerical values returned by those responses or if you want to count the
number of "Yes" responses across several fields.

If all you want to do is count the number of items that where checked:

Calc field (number result) =

Case (
Is Empty (FieldName), 0,
PatternCount (FieldName, "?") + 1)

(where ? = return character)

The first test eliminates the possibility that there were no responses and
returns 0 in that event.

The second test counts the number of return characters in the field.  All
values stored in a  check box field (except the last value) are separated
by returns (to see this for yourself, make another copy of the field and
format it as an standard field) so its just a matter of counting the
returns and adding one for the last value.  If there is only one value,
there will be no returns so the second test adds 1 to 0 (return
characters) and returns 1.

If its something else, could you please post again to clarify the issue.

--
Bridget Eley