Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    NOT - Multiple Criteria

    Sorry, I know this is basic stuff.



    Seemingly simple problem but haven't been able to find the answer on the web or searching in the forum

    I want to filter out multiple criteria in a query. (if it matters I am filtering out table ID#, if that makes sense)

    I know

    <>1 And <>2 And <>3 ........ And <>24

    will work, but cant seem to find a simpler way i.e. <> 1 - 24

    As always, Thanks for the help

    Click image for larger version. 

Name:	Capture.PNG 
Views:	15 
Size:	26.2 KB 
ID:	47764

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Perhaps
    < 1 or > 24
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 04-24-2020, 11:36 PM
  2. Replies: 2
    Last Post: 04-02-2015, 12:45 PM
  3. Replies: 2
    Last Post: 04-10-2013, 03:54 PM
  4. Replies: 7
    Last Post: 01-02-2013, 11:23 PM
  5. Replies: 1
    Last Post: 07-13-2011, 11:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums