J josephyeo Registered User. Local time Today, 13:23 Joined Dec 10, 2000 Messages 13 Dec 23, 2000 #1 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.
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.
Fornatian Dim Person Local time Today, 13:23 Joined Sep 1, 2000 Messages 1,396 Dec 23, 2000 #2 I think you want to do a conditional sum iif statement. =Sum(Iif(Me!Colors="Red",1,0))
J josephyeo Registered User. Local time Today, 13:23 Joined Dec 10, 2000 Messages 13 Dec 23, 2000 #3 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.
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.
Fornatian Dim Person Local time Today, 13:23 Joined Sep 1, 2000 Messages 1,396 Dec 24, 2000 #4 And a Merry Christmas to you too!!
