Search results

Below is what I posted a few days ago. Let me see if I can ask it any differently. I basically need to know if it is possible in a query to have 2 operators so that you can pull a value "=" and a value "between". Can you make both a "=" and "Between" value set for one category? ie...

Can you make both a "=" and "Between" value set for one category? ie. [Patent]=[Forms]![WDCRPD]![Patent1] And [Forms]![WDCRPD]![Patent2] And [Forms]![WDCRPD]![Patent3] And [Forms]![WDCRPD]![Patent4] Or [Forms]![WDCRPD]![Patent1] Is Null Or [Forms]![WDCRPD]![Patent2] Is Null Or...

In the following code I would like to add a user input criteria expression selectible through a form combobox with three option to select from And/Or/Not Like "*" & [Forms]![Test]![AbstractBox] & "*" And Like "*" & [Forms]![Test]![AbstractBox2] & "*" And Like "*" &...