• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Exclude Multiple Values from Query (1 Viewer)

gselliott

Registered User.
Local time
Today, 09:18
Joined
May 17, 2002
Messages
106
I know this is probably very easy but I just can't think how to do it. I want to be able to exclude any records in my query that have certain codes (4 codes) I can get the query to work excluding only 1 but it will not work with any more. Anyone any Ideas I have tired <> "Code1" or <>"Code2" etc.

Thanks in advance
 

namliam

The Mailman - AWF VIP
Local time
Today, 10:18
Joined
Aug 11, 2003
Messages
11,668
try using and... instead of or...

<> "Code1" and <> "Code2" ...

regards
 

DawnDesM

New member
Local time
Today, 02:18
Joined
Feb 14, 2014
Messages
5
I used- Not In ("Code 1","Code 2","Code 3")

Good luck!
 

Users who are viewing this thread

Top Bottom