If statement based on null table contents

[Z34Lee]

I'm looking to create something like this:

If [FieldName] of any of the records is equal to null Then

It would also be nice to count the instances in which those fields are equal to null to use later in the application. Any suggestions? I don't know how to cycle through a recordset like that.

 

[FoFa]

SELECT COUNT(*)
FROM YourTableName
Where YourTableName.YourFieldName IS NULL

Basically

 

[Z34Lee]

I'll try it out. Thanks!

 

[Z34Lee]

The SQL statement works great, thanks for that. I'm having a hard time calling that value in my code's "if" statement though.