Counting Checkboxes based on another column in report footer

[-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?

 

[Duane Hookom]

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