Return records with null value

S

Sirocco

I'm passing a combobox value in a form to a query - basic stuff. But I want
the query to return records with null values for this field if I leave the
combobox blank. Logically, this should work, but doesn't. Any assistance
would be greatly appreciated.
 
M

MacDermott

The "trick" in the logic is that you can't check for a Null value with an =
operator.
Check for a Null value with IsNull.

If you need more detailed help, perhaps you could post the SQL for your
query.

HTH
- Turtle
 
Top