How do I make my textbox count only specified records - like "Colors="RED"

My textbox control source says: Count(Colors) - results in counting all the records.

I think you want to do a conditional sum iif statement.

=Sum(Iif(Me!Colors="Red",1,0))

Many thanks. I have read many of your replies to other people. It's people like you who takes the time to help others that makes this place a better world. Thanks again. Jo.

And a Merry Christmas to you too!!