Multiple Criteria

[lledar]

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 [Forms]![WDCRPD]![Patent3] Is Null Or [Forms]![WDCRPD]![Patent4] Is Null

[Patent] Between [Forms]![WDCRPD]![PatRangeLow] And [Forms]![WDCRPD]![PatRangeHigh] Or [Forms]![WDCRPD]![PatRangeLow] Is Null Or [Forms]![WDCRPD]![PatRangeHigh] Is Null

I would like to return both exact values and/or a range of values. Is it possible?

 

[lledar]

I believe I have come up with a different solution using frames that turn off and on depending on which query I want to perform. I still would like to know if above can be done. Thanks