not or <> "string" query

  • hello,
    im currently using a query which doesnt want to include a certain string ie Lead. the column that i do this criteria search on has many other strings and empty strings, so when i use the criteria not "Lead" or <> "Lead" the filter seems to work but also filters away the blank strings..... is there any other way to filter out the string lead which doesnt also filter out the blank entries????




    Cheers
    Mike

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!