Query Criteria

[rwalle]

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

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