Count different values in text box

[naminder]

Trying to get this to work, on a continous form i have a text box in the footer to count no of records.

Want to count all that have a "B" for their value. Why won't this code work in the footer text box source

=Count([strFKBedContractTypeID])="B"

 

[alastair69]

have you tried having the "B" inside of the ():

so could look like =Count([strFKBedContractTypeID]="B")

 

[naminder]

Yep, didn't work just counts all records. I know it's probably a stupid typo, noticed your from my neighbourhood

EDIT:

found an answer, i needed to Sum and use an IIf to compare, cheers

=Sum(IIf([strFKBedContractTypeID]="B",1,0))