Click to See Complete Forum and Search --> : counting nulls


Mat Davis
March 19th, 2001, 03:34 PM
i'm trying to count null fields in an access db -and failing.
This is what is failing :
If Data1.Recordset("name") = NULL Then
num = num + 1
If i debug it i can see that the field is null but it still tests as false.
Any help please ?
Thanks in advance,
MD.

Mat Davis
March 19th, 2001, 03:40 PM
ooops wrong category. sorry.
MD.