Skip to main content
J
jamie61880
Inspiring
February 24, 2012
Answered

Not Equal to

  • February 24, 2012
  • 1 reply
  • 645 views

Hi. I'm just trying to get some rows to not show up on my display page that have a "D" in the Dismiss_Parts column. This is what I have in the Query to do this:

And Dismiss_Parts <> 'D'

It removes the rows with the D in them, but it also removes all the other rows. Does anyone know why this would be, or if there is anything else I can try to make it not equal to a "D"? I've tried NEQ, <>, and Not Like, but nothing works.

Thanks.

Andy

    This topic has been closed for replies.
    Correct answer jamie61880

    I figured this out. Here's what I did:

    And (Dismiss_Part_Number <> 'D' Or Dismiss_Part_Number Is Null Or Dismiss_Part_Number = '')

    1 reply

    J
    jamie61880AuthorCorrect answer
    Inspiring
    February 24, 2012

    I figured this out. Here's what I did:

    And (Dismiss_Part_Number <> 'D' Or Dismiss_Part_Number Is Null Or Dismiss_Part_Number = '')

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices