Counting Checkboxes based on another column in report footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try a control source in your report footer of:
=Sum(Abs(IsNull([Column A]) AND [Column B] = True) )
 
Back
Top