IIF in Query Criteria

[GROG600]

based upon selection from a form, I would like to vary the selection criteria in a query. for example

query field expr1,

crieria :

IIF([forms]![frm1]![option1]= true, &quot;<45&quot;, &quot;=45&quot

This doesn't work, any suggestions?

PS I know how to do it building an SQL statement in code, however, it is our corporate policy to use querys as often as possable, makes it easier for others to pick up and understand your work !

Thanks in advance.

 

[r937]

select stuff
from yourtable
where [forms]![frm1]![option1] = true
and something < 45
union all
select stuff
from yourtable
where [forms]![frm1]![option1] = false
and something = 45

only one side of the union will return rows

rudy

http://rudy.ca/

 

[GROG600]

thanks so much for your help.