Database Results

[Guest]

How do I compare a field from a database. If the value is null the I don't want the field to display on the screen. Please help

 

[Kathleen Anderson [MVP - FP]]

How do I compare a field from a database. If the value is null the I
don't want the field to display on the screen. Please help

Numeric Field Queries

Using the Is Null comparison:
SELECT * FROM Categories WHERE (CategoryID IS NULL)

Using the Is Not Null comparison:
SELECT * FROM Categories WHERE (CategoryID IS NOT NULL)

Text Field Queries

Using the Is Null comparison:
SELECT * FROM Categories WHERE (CategoryName IS NULL)

Using the Is Not Null comparison:
SELECT * FROM Categories WHERE (CategoryName IS NOT NULL)

From: http://support.microsoft.com/default.aspx?scid=kb;[LN];306430