locked
Query filtering out blanks when using <> operator RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have a table with 6 fields. the last field is text field and has Required =No. There is some data in the field and some blanks. When I do a query with WHERE field6<>'XXXXX', it filters out 'XXXXX' as well as all the blanks. HOw do I get it to just filter out 'XXXXX' and leave the blanks?
    Monday, July 23, 2018 6:11 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    I just did (field6<>'XXXXX' OR field6 is null)
    • Marked as answer by JHarding08 Monday, July 23, 2018 7:27 PM
    Monday, July 23, 2018 7:27 PM