Need to identify an empty field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a report based on a query but some of the entries will have a
field that is blank. How do I identify this field, I've tried using Null but
that doesn't work and I've tried using "". It is a numeric field.

Thanks,

Steve
 
When checking for a Null criteria you need to write

Is Not Null

and not <> Null

or, Is Null instead of = Null

If the above is not the case, can you post the full SQL?
 
Works great thanks.

S

Ofer Cohen said:
When checking for a Null criteria you need to write

Is Not Null

and not <> Null

or, Is Null instead of = Null

If the above is not the case, can you post the full SQL?
Click to expand...
 
In a query you would use Is Null as criteria (not "= Null").

In VBA you would use the IsNull function. IsNull(Something) = True or
IsNull(Something) = False.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top