Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Location
    Raleigh, NC
    Posts
    146

    Unanswered: Query that omits records?

    I can setup a query that selects certain records, but my question is, how do omit certain records from a query. For instance, if I have the following list of numbers:

    23, 488, 49, 38, 144, 36, 100

    I want the query to return all records matching every number EXCEPT 36 and 38. How would I go about doing that?

    Something like:

    Criteria: NOT 36,38

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    SELECT * FROM SomeTable WHERE (SomeColumn NOT IN (36,38));
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Close...

    NOT IN (36, 38)
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Teddy
    Close...

    NOT IN (36, 38)
    We tied this time ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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