Results 1 to 2 of 2

Thread: How to use a field as "Not Something" to be condition of a query

  1. #1
    Board Regular
    Join Date
    Dec 2004
    Posts
    664
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to use a field as "Not Something" to be condition of a query

    I have a table with one column storing the condition of a query, like "*" etc.
    * means all countries
    Now, apart from "*", there is a need to have a condition "Not US"

    So, can we join table has same effect as "[Country] is not US" ?
    What can I do ?

  2. #2
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,081
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    2 Thread(s)

    Default Re: How to use a field as "Not Something" to be condition of a query

    Maybe best to have more information

    though the basic idea is : [Country] <> 'US'
    or if you need to add some other exceptions, you might prefer [Country] NOT IN ('US', 'AnotherOne', 'OrTwo')

    And if there can be Null entries in the field, be careful to correctly handle them
    If you've posted a clearly explained question & sample data - both input & corresponding output - that can be copied to Excel, THANK YOU.
    Google can find answers to nearly every question.


Some videos you may like

User Tag List

Tags for this Thread

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
  •