How do I query for a 'no' answer on a check box field?

Posted on 2009-04-23
Last Modified: 2013-11-28
I need several queries to find a list of athletes that don't have paperwork.  The table has been designed as check box fields.

  AthleteID - pk autonum
  AthLName - text
  AthFName - text
  Transcript - yes/no
  Paid - yes/no
  Waivers - yes/no
  Registered - yes/no

So for example;  I need a query or report that will show all athletes where Transcript is "No".

I can then adapt that query for each yes/no field.

Thanks in advance.
Question by:tbronc
    LVL 39

    Accepted Solution

    Try like this

    SELECT *
    FROM Athletes
    where Transcript = No;

    For YEs

    SELECT *
    FROM Athletes
    where Transcript = Yes;


    Author Closing Comment

    PERFECT!  I am a noob when it comes to databases and have a project that needs to be completed right away!  The things we do for friends!

    Thank you very much

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now