Using a filter to exclude records from a table

  • Thread starter Thread starter Shane
  • Start date Start date
S

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.
 
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
 
Or, since Shane said "if 'field1' is blank and 'field2' is blank do not
display."
Click to expand...
(ahem...)

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



B Wishes


Tim F
 
Back
Top