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) =
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.
> I have created a database for survey results. I entered test data to use in
> creating summary reports. I need to know how to do the following:
> 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
> Also - I have four different responses possible in a single text field.
> 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
> layouts and reports the way I want them.
> Thanks for any help with this.