count certain records in a report

G

Guest

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
 
G

Guest

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

Column wrap a single field into 2 or more columns per page? 2
counting records 0
Counting Types of fields in a Report 4
Multiple Records in One Report Field 1
How do I restrict count of records if = to certain words 1
Count IIF 1
Change text box background color depending on value in Label Reports 1
display the value depending on logical condition 2

Top