Results 1 to 3 of 3

Thread: Query

  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query

    I am doing a query on a table that has a yes/no check box. I want only the records that have not been checked. I have used "Is Null" in the criteria but this does not work. Can someone help me out. Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query

    DID YOU SET THE CRITERIA AS "IS NULL" OR Is Null. if you set the critera as "IS NULL" You will be searching for the actual words IS NULL instead of null
    jerryc

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Query

    Hi,
    Try setting the criteria to No or to False or to 0 (zero not O). For a yes/no field checked is yes/true/-1, unchecked is false/no/0.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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