Q: A Summary for a Value List

[fm31]

Can someone help? I have a simple checkbox value list of personnel... Selected are those in attendance... I would like to show a total of attendees on the working record... Can this be done? [color:"#666666"]

[Chuck]

Check boxes are actually stored by the field containing each of the checked items separated by a return. You can see this by checking multiple items and then placing a copy of the field on the layout that isn't formatted as a checkbox. By counting the returns you can tell how many items are checked. There would be one less return than there are items checked.

PatternCount( ValueListField, "

[fm31]

Thanks so much Chuck... Works great!