Null value field

S

Samuel

Hi

I would like to find out whether a field has a value i.e. is it null.

What is the syntax to do that?

Samuel
 
J

John W. Vinson

Hi

I would like to find out whether a field has a value i.e. is it null.

What is the syntax to do that?

Samuel
Click to expand...

In SQL query criteria:

Fieldname IS NULL

in VBA code (you can use it in calculated expressions in SQL too):

IsNull([fieldname])

John W. Vinson [MVP]
 
Top