Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • 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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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