Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query, include records with null in multiple field (Access 2000)

    I have a query with three fields I want to search on. I want records selected if field1 Is Null or Field2 Is Null or field3 Is Null. I do not want field1 Is Null and Field2 Is Null and field3 Is Null. How do I go about doing this?

    Thanks
    Mike

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query, include records with null in multiple field (Access 2000)

    You can create a query like in the screenshot below. If you explicitly want to exclude records for which all three fields are null, add a calculated column

    IsNull([Field1]) And IsNull([Field2]) And IsNull([Field3])

    Clear the Show check box for this column, and set the Criteria for this column to False in all three criteria rows.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query, include records with null in multiple field (Access 2000)

    Hans,

    Thant worked perfectly.

    Thanks
    Mike

Posting Permissions

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