Null value field

[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

 

[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

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]