N n6trf Nov 3, 2008 #1 How do I count in the report header the number of times a field is 'true' as opposed to 'false' ... ? TIA
How do I count in the report header the number of times a field is 'true' as opposed to 'false' ... ? TIA
A Allen Browne Nov 3, 2008 #2 n6trf said: How do I count in the report header the number of times a field is 'true' as opposed to 'false' ... ? TIA Click to expand... Use a text box with Control Source of: = - Sum([YourYesNoFieldNameHere]) In Access True is -1 and False is 0, so summing gives the negative count of checked boxes.
n6trf said: How do I count in the report header the number of times a field is 'true' as opposed to 'false' ... ? TIA Click to expand... Use a text box with Control Source of: = - Sum([YourYesNoFieldNameHere]) In Access True is -1 and False is 0, so summing gives the negative count of checked boxes.
