Count Is Null

[matrixindicator]

I have a recordset counting the fields with a value "is not null". It works fine. I try to use the same sql to count the total of field with no value (is null). This is not working (also the query in design view is not working).

Set rst = dbs.OpenRecordset("SELECT Count(" & name & ") AS TotKolomNull " _
    & "FROM IMPORT " _
    & "HAVING (((Count(" & name & ")) Is Null))", dbOpenDynaset)

 

[Remou]

How about:

Set rst = dbs.OpenRecordset("SELECT Count(*) AS TotKolomNull " _
    & "FROM IMPORT " _
    & "WHERE " & name & " Is Null", dbOpenDynaset)