Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

have a query that <> certain names- but still want null values to display

I have a query in test database- qry1
I don't want certain records to display in the categories field-
<> PC <> Obsolete and <> Parts Area
But when I run query - it also does not display records that have a null value in that field- i
Is there a way to also display the records with nothing entered for categories field?
thank you
1 Solution
Rey Obrero (Capricorn1)Commented:
try this where clause

WHERE [Categories] Not In ("PC","Obsolete","Parts Area") OR [Categories] Is Null
davetoughAuthor Commented:
Thank you

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now