criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help! I have several fields in a query that are yes/no fields. I want to
show all of the fields in the query that are "no". But can only get the
first field to show on the query results. I use ="No" in the first field,
but if I enter ="No" in the other yes/no fields it doesn't show anything.
 
Help! I have several fields in a query that are yes/no fields. I want to
show all of the fields in the query that are "no". But can only get the
first field to show on the query results. I use ="No" in the first field,
but if I enter ="No" in the other yes/no fields it doesn't show anything.
Click to expand...

The value of a Yes/No field is a Number value, -1 or 0.
="No" is Text.

As criteria write:
=0
If there are many different Yes/No fields, write each criteria on the
next row down for each Field. This will result in an Or criteria:
Where [Check1] = 0 OR [Check2] = 0 OR ..... etc.
 
Susan said:
Help! I have several fields in a query that are yes/no fields. I want to
show all of the fields in the query that are "no". But can only get the
first field to show on the query results. I use ="No" in the first field,
but if I enter ="No" in the other yes/no fields it doesn't show anything.
Click to expand...

Hi Susan,
if your criteria is:
Select all records where at least one of yes/no field is no
then
you have to put the criteria on different criteria Lines.
The query will be something like this:

SELECT * From YourTable
WHERE [Fld1]=no OR [Fld2]=no OR [fld3]=no .....


Bye
 
Back
Top