Count number of ticks returned by Lookup, where field is a Checkbox


#1

I have a Lookup which points to a Checkbox field on another table. The Lookup returns a ‘tick’ character for each of the records where a tick is present.

(The field called “Present” is the Checkbox. The ‘tick’ characters that are returned can be seen beneath the ‘Cancel’ button.)

What formula should I use in order to return a count of the number Checkboxes which have been ticked?

Graham


#2

OK. Thanks to the excellent Help files, I’ve discovered that I can achieve this as follows:

Problem solved!

G