Yes/No times 2

[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~

 

[Guest]

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));

 

[fredg]

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~

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

 

[Guest]

Kasab..

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

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~