Countif would make it so easy.

[Huddle]

I am trying to count the number of records that have criteria of FSL = 0, 1, 2, 3 and 4. After research this I found a way to do this was make a calculating IIf field then have a seperate field do the count. This is what I've done but it is not working. Any suggestions.

=IIf([FSL]=0,1,0) (named this field 0CountCal)
=Count([0CountCal])

Used the same formulas for 1,2,3 and 4

[Robeen]

Are you doing this in a Query?
Do you need a count for EACH of the FSL numbers?
Eg:

FSL	Count
	15
1	27
2	5
3	17
4	98

Is that kind of what you need?

[orange]

SELECT Count(FSL) AS CountOfFSL, FSL
FROM YourTableName
GROUP BY FSL
HAVING (((FSL) In (0,1,2,3,4)));



A query along these lines should work, assuming FSL is a numeric datatype

[Huddle]

I'm doing this in a sub report in unbound fields. I figured I'll have to do the calculations in the subreport then put it in the main report. I've attached an example. Just another one of my messes.