It sounds like you need to restructure your database so that each attendance "mark" is in it's own record. That would make counting values and reporting those counts much simpler.
Count ( gAttentionHoldFields )
Can only return either 1 or 0. If gAttentionHoldFields is empty, it returns 0. If it is not empty, it returns a 1. If you look up count in Help, this is exactly what it does, count the number of fields that are not empty. It has no way to evaluate the text in this field to get multiple values to count.
Consider this expression instead:
Evaluate ( "Count ( " & gAttentionHoldFields & ")" )
Thanks my friend, that is exactly what I needed...works great! BTW, I may not have been very clear in my explanation but each attendance mark is a field in each record.
If so, then you do not need to use such a complicated method. For one thing, the field name would be the same for every attendance mark and you could use:
Count ( related table::field),
a summary field
to count your attendance.
PS. I once set up an attendance solution for a children's ministry and did not need anything but th above to get my counts.