• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

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

I need several queries to find a list of athletes that don't have paperwork.  The table has been designed as check box fields.

Table:
Athletes
  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.
0
tbronc
Asked:
tbronc
1 Solution
 
Pratima PharandeCommented:
Try like this

SELECT *
FROM Athletes
where Transcript = No;

For YEs

SELECT *
FROM Athletes
where Transcript = Yes;

0
 
tbroncAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now