Counting query yes/no and is not null

[Pusher]

Hi all,
I have a query that counts by month. It works fine when you count separately the yes/no field and is not null field but when I try to put them in the same query I get the same number in both counting fields.
Is there a way for this to work?
Thanks

SELECT Month([DATUM_IZVESTAJA]) AS MESEC, Count("ID_GRESKE") AS [BROJ ISPADA], Count("HAVARIJA") AS [BROJ HAVARIJA]
FROM IZVESTAJ
WHERE (((IZVESTAJ.HAVARIJA)=True)) OR (((IZVESTAJ.ID_GRESKE) Is Not Null))
GROUP BY Month([DATUM_IZVESTAJA]);

 

[plog]

I don't know if I completely understand this, but I think you want to apply your WHERE criteria independently of each other. Try this:

SELECT Month([DATUM_IZVESTAJA]) AS MESEC, SUM(IIf(IsNull([ID_RESKE])=False, 1,0)) AS [BROJ ISPADA], SUM(IIf([HAVARIJA])=True, 1,0)) AS [BROJ HAVARIJA] 
FROM IZVESTAJ
GROUP BY Month([DATUM_IZVESTAJA]);

If not, post some sample input and output of the query.

 

[Pusher]

That did it Only one thing - how can i make it read January, February an so on, and not 1 2 3

 

[plog]

Use the MonthName function:

SELECT MonthNane(Month([DATUM_IZVESTAJA])) AS MESEC, SUM(IIf(IsNull([ID_RESKE])=False, 1,0)) AS [BROJ ISPADA], SUM(IIf([HAVARIJA])=True, 1,0)) AS [BROJ HAVARIJA] 
FROM IZVESTAJ
GROUP BY Month([DATUM_IZVESTAJA]);

 

[Pusher]

MonthName thanks