'COUNTIF' on a Report using an expression?

[RogerC]

I have query that contains a field called ITEM COLOR. The records for ITEM COLOR are either 'Blue' or 'Red'. I have created a report from the query and I would like to put a text box on my report that shows the total number of 'Blue' records that occur in ITEM COLOR. Can I do this using the Expression Builder'? I don't see a COUNTIF function in the Builder.

 

[Mile-O-Phile]

Lookup the DCount function.

 

[u0107]

positioning the cursor on the field in the query in the Design View, right click and check on Totals..


You will get an additional row in the design.. in the Sum, you will get a drop box in which Count is an option.. that wil contain the count

In the criteria, you can specify Green or Blue

Create two new columns to count the occurrences.

Hope this helps.

Cheers!

Uttam