Results 1 to 2 of 2
  1. #1
    Bdowns is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    28

    Select from query that excludes records based on a field criteria, but retains null..

    I am trying to write a query that excludes all of a particular entry in a field, but still displays entries in which that field is blank. The table is for species observations and I want to exclude records in which "cucumbers" appear in the invert field. When I enter Not "cucumbers" for the invert field criteria, I only see records in which there was an invert recorded, and it was not a cucumber . I want to retain all records, whether and invert was observed or not, except for those in which the invert was a cucumber. Any help would be greatly appreciated. Thanks

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    What is an "invert"?

    We only know what you tell us and you haven't said much.

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

Similar Threads

  1. Replies: 4
    Last Post: 08-02-2012, 10:59 AM
  2. If/Then Null based on Null Value of Another Field
    By vbpeterson in forum Queries
    Replies: 11
    Last Post: 06-05-2012, 05:00 PM
  3. Replies: 1
    Last Post: 02-23-2012, 02:27 PM
  4. data field in query twice based on criteria
    By sandyg in forum Queries
    Replies: 1
    Last Post: 09-29-2011, 07:47 AM
  5. query - criteria based on another row field value
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 05-29-2009, 04:17 PM

Tags for this Thread

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