Counting Checkboxes based on another column in report footer

B

-Backspace-

Hi,

I want to count checkboxes (yes/no) only if another colum is blank.
Ex. Column A = Date, Column B = Checkboxes
I only want a count of Yes check boxes in Colum B, if Column A is Blank (no
date entered)
Is this possible?
 
D

Duane Hookom

Try a control source in your report footer of:
=Sum(Abs(IsNull([Column A]) AND [Column B] = True) )
 
Top