How to show both Yes/No in a query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PerryC - 09 Nov 2004 14:35 GMT

I have a query and a InputForm.

Query:
Field1 (Yes/No)
Forms![InputForm].[CheckBox]

What I wanted: If user do not click CheckBox, Query will show ONLY the
No records; however, if Users check that Checkbox, it shows BOTH the
YES/NO records. (Bear with me on this poor explaination)

Sincerely,
Perry

Reply to this Message

Steve Jorgensen - 09 Nov 2004 14:45 GMT

>I have a query and a InputForm.
>
[quoted text clipped - 8 lines]
>Sincerely,
>Perry

To do it with a single query, the key is that you always want No records, so
the condition is that the record is No or the checkbox is unchecked. That
means a record will only be excluded if it is Yes, and the checkbox is
unchecked.

SELECT tblMyTable.* FROM tblMyTable WHERE tblMyTable.Field1=False OR
[Forms]![InputForm].[CheckBox]=False

Reply to this Message

Perry Cheng - 09 Nov 2004 17:06 GMT

Thanks a lot. That works perfectly.

Reply to this Message