Yes/No times 2

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

Guest

Hi all..

I have a query pulling from the main table that has two yes/no check
boxes. The query works fine when I have just one of the yes/no marked as
"Yes".. But I would like to have it also pull the second yes/no if it is
also checked.

So if #1 is checked yes>>display
If #2 is checked yes>>display
If both #1 and #2 are checked yes>>display

How would I go about doing this??

Thanks
R~
 
In the query grid, enter Yes into the Criteria row of one of the fields and
then enter yes into the OR row of the other field.

The SQL for just these 2 fields is: SELECT field1, field2
FROM

WHERE (((field1)=Yes)) OR (((field2)=Yes));
 
Hi all..

I have a query pulling from the main table that has two yes/no check
boxes. The query works fine when I have just one of the yes/no marked as
"Yes".. But I would like to have it also pull the second yes/no if it is
also checked.

So if #1 is checked yes>>display
If #2 is checked yes>>display
If both #1 and #2 are checked yes>>display

How would I go about doing this??

Thanks
R~
Click to expand...

Where YourTable.[Check1] = -1 OR YourTable.[Check2] = -1
 
Kasab..

That was too easy.. Thank you!!!!!

R~

kasab said:
In the query grid, enter Yes into the Criteria row of one of the fields and
then enter yes into the OR row of the other field.

The SQL for just these 2 fields is: SELECT field1, field2
FROM

WHERE (((field1)=Yes)) OR (((field2)=Yes));


Rhett_Y said:
Hi all..

I have a query pulling from the main table that has two yes/no check
boxes. The query works fine when I have just one of the yes/no marked as
"Yes".. But I would like to have it also pull the second yes/no if it is
also checked.

So if #1 is checked yes>>display
If #2 is checked yes>>display
If both #1 and #2 are checked yes>>display

How would I go about doing this??

Thanks
R~
Click to expand...
Click to expand...
 
Back
Top