Need Help - How to Count Yes/No Type in Reports

[dkmidi]

Hi there,

I have a table that has one field set up as Yes/No type. I've created a report but how can I count only the "Yes" responses to a question? I've tried using a statement like =iif([mytable]![Certified]=Yes, count([mytable]![certified],)

The above is just an example but does anyone know how to count only the Yes responses or only the No responses? Thanks!

dk

 

[richieuk]

Sum(Iif([MyField]=Yes,1,0))

 

[dkmidi]

Hey thanks Richie!!

 

[WildHare]

Or you could always

Sum(MyField) * -1 to get the YESs,

Count(myField) - (Sum(MyField)* -1) to get the NOs

Or to just do it all at once..

SELECT Count(Table1.YESNO) AS CountOfYESNO, Sum([YESNO])*-1 AS YESCOUNT, Count([YESNO])-[YesCount] AS NOCOUNT
FROM Table1;



Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com