Count records if

[visidro]

Would like a little help with counting records that match a string if a
check box field is true or checked.
I am building a form to display record counts but only for records that are
active (checked) In other words if field a=music and field b=true then count
it

can someone help me with this , much appreciated.

 

[fredg]

Using an unbound text control:
=Sum(IIf([FieldA] = "Music" and [FieldB] = True,1,0))

Fred

 

[visidro]

that works great, thank you very much!

Using an unbound text control:
=Sum(IIf([FieldA] = "Music" and [FieldB] = True,1,0))

Fred

Would like a little help with counting records that match a string if a
check box field is true or checked.
I am building a form to display record counts but only for records that are
active (checked) In other words if field a=music and field b=true then count
it

can someone help me with this , much appreciated.