Results 1 to 2 of 2

Query criteria = Does Not Contain ?

This is a discussion on Query criteria = Does Not Contain ? within the Microsoft Access forums, part of the Question Forums category; I've looked here and in a couple books and not found the answer to this... All I'm trying to do ...

  1. #1
    Board Regular
    Join Date
    Apr 2003
    Posts
    343

    Default Query criteria = Does Not Contain ?

    I've looked here and in a couple books and not found the answer to this...

    All I'm trying to do is apply something similar to Excel's "Does Not Contain" filter as a criteria in a query. For example, I want to return all records where the given field does not contain: Comp

    How would I enter that?

    Thanks for the help, and I'm sorry for what is probably a very simple question.

  2. #2
    Board Regular
    Join Date
    Apr 2003
    Posts
    343

    Default

    Nevermind, I think I found it...

    Not Like "*Comp*"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com