Count(*) does not work for null values

[sifar786]

hi,

i m trying to run a query on an MSAccess table, but it does not give me any count but only 0.

There are 3 null values which i should be getting but it does not give me the result. This query works perfectly in MSSql Server 2008.

the query is :

SELECT COUNT(*) AS Cntr
FROM (Modul m LEFT OUTER JOIN
Relation r ON m.Mod_Name = r.von)
WHERE (m.[group] = '')

I need a workaround for this but am unable to find one. Any help would be most appreciated.

[Enub]

IF you can get it to work by creating a query in MS Access, you can then open that query in "SQL View" and it will spit it out for you. I don't know if Access has a count function though.

Good luck

[sifar786]

I did not understand what you meant.

Though i found a workaround for it:

SELECT COUNT(*)-1 AS Cntr
FROM (Modul m LEFT OUTER JOIN
Relation r ON m.Mod_Name = r.von)
WHERE (m.[group] = '') or (m.[group] IS NULL)