Null value field

  • Thread starter Thread starter Samuel
  • Start date Start date
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
 
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]
 
Back
Top