counting nulls

[Mat Davis]

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.

[Iouri]

That must work
If IsNuLL(Data1.Recordset("name")) Then
num = num + 1


Iouri Boutchkine
iouri@hotsheet.com

[Mat Davis]

that works. Thanks for the help.
MD.