Using a filter to exclude records from a table

[Shane]

I am new to access. I need to apply a filter to my table
that will exclude records that do not have an entry
in "field1" or "field2". In other words if "field1" is
blank and "field2" is blank do not display.

 

[Sal Rosario]

SELECT *
FROM TableName
WHERE field1 Is Null OR field2 Is Null

--
Regards,

Sal Rosario
Database Cosultant in NJ
www.salrosario.com

 

[Douglas J. Steele]

Or, since Shane said "if 'field1' is blank and 'field2' is blank do not
display."


SELECT *
FROM TableName
WHERE field1 Is Null AND field2 Is Null

 

[Tim Ferguson]

Or, since Shane said "if 'field1' is blank and 'field2' is blank do not
display."

(ahem...)

SELECT *
FROM TableName
WHERE NOT ( field1 Is Null AND field2 Is Null )



B Wishes


Tim F

 

[Douglas J. Steele]

Ooops! Thanks for recovering my fumble, Tim!