Hi All,
I have a field with check boxes, 24 values.
I count the checked values per record with the ValueCount() function. Works great.
Now I need a way to know how many checked boxes per record in a found set.
Example.
Record 1 - 5, 3 boxes checked
Record 6, 4 boxes checked
Record 7 - 12, 6 boxes checked
Result:
5 records with 3 boxes checked
1 record with 4 boxes checked
6 records with 6 boxes checked
Any hint how to start ?