Use IIf condition to return < (less than) or > (bigger than)

[M3RiM]

Hello everyone

I can't understand what is the problem in my IIF condition.

By typing this condition in Criteria
IIf([Forms]![Formname]![CheckBox]=True; =>[Forms]![Formname]![Textbox]-1; <[Forms]![Formname]![Textbox]-1)
it doesn't return anything

If I tipe in the Criteria field only the value_if_true


=>[Forms]![Formname]![Textbox]-1
it returns exactly what I want

the same with value_if_false
it works great

but in the IIF condition it doesn't work

please help

thanks and best regards
Merim

[June7]

The logical operators cannot be dynamic.

I would not use dynamic parameterized query. I would use VBA to build criteria string and apply to form or report. Review http://allenbrowne.com/ser-62.html

[M3RiM]

really not happy to hear that.

I though to do it in VBA but in this case my db would requires more queries to filter data to use them in the VBA.
though to do it easily in the query, but unfortunatelly I was unlucky

OK, thanks anyway.
i will try to solve it somehow

[CJ_London]

try the following

have a column populated with [Forms]![Formname]![CheckBox] (you can untick the show option since it does not need to be returned in your query
on the first criteria line put =>[Forms]![Formname]![Textbox]-1 - and on the checkbox column put True
on the second criteria line put <[Forms]![Formname]![Textbox]-1) - and on the checkbox column put False

if you have other criteria you will need to repeat on the second line

Not tested but I think another way would be just for one line

(=>[Forms]![Formname]![Textbox]-1 AND Forms]![Formname]![CheckBox]=True) OR (<[Forms]![Formname]![Textbox]-1 AND Forms]![Formname]![CheckBox]=False)

[M3RiM]

Thanx Ajax

this is it

The OR solved my problem. It works as I wish
It would never fell on my mind

Thanks a lot !!!

Best regards