count certain records in a report

A

Aurora

I am using Access 2003
I have a report in which each record contains one text field that is
Code: 
.
Ex:  The [code] text field can be, "Red, Green,Yellow or White".  I need to
count the number of records that are coded Red, Green or Yellow (all
together) but not include the White.  How can I do this?  Can anyone help me?

aurora
 
O

Ofer Cohen

Try using in the control source of the field in the report

=Sum(IIf([Color field name] = "White",0,1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Change text box background color depending on value in Label Reports 0
Copy previous record into form field 0
color coding values 0
Subtotal for text fields 0
A03 - count in report footer gives me #Error? 0
Creating Labels Over 3-Up Image 2
Really getting desperate... help required, please ! 0

Top