By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,523 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Query Criteria

P: 47
HI

I have a form that has a subform inside that display data based on dates I do write on Text boxes on main form, this dates are sento to the query and It works as expected but now I want to filter also based on a field (YES / NO) that is on subform's query, and the thing is I'd like to set a combo box on main form and send this value to query but I dont know how to do it since my field expect Yes / No; 0 or 1 ; and I'd like to have 3 options Yes / No and Both Yes and No, I could make it work for each state 0 Or 1 but I don't know how to express the condition 0 Or 1 ,I mean using a field value

Any help will be appreciated

Raymundo Walle
Jan 19 '10 #1

✓ answered by nico5038

One option is to use two queries, one with no Yes/No filtering and another with.
Depending on the selection of the Yes/No/All combo you activate the one or the other query as the forms recordsource.
Another option would be to use a LIKE operand and besides True and False use '*" for the "All" situation.

Nic;o)

Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
One option is to use two queries, one with no Yes/No filtering and another with.
Depending on the selection of the Yes/No/All combo you activate the one or the other query as the forms recordsource.
Another option would be to use a LIKE operand and besides True and False use '*" for the "All" situation.

Nic;o)
Jan 22 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.