What's wrong with this IIF expression

[DanSmith]

Hello,

I have added this IIF expression in the criteria in a query:

IIf([Forms]![Open_Form]![CLAMT_BET] Is Null;[Tbl_MainWeekly]![Credit limit]; Between [Forms]![Open_Form]![CLAMT_BET] And [Forms]![Open_Form]![CLAMT_and])

When the field CLAMT_BET is empty I get all the data which is what I want. However, when it is not empty, instead of having the "between....and" I get all the records which are at 0

Any idea will be aprreciated ?

Thanks

Cheers Dan

 

[Jon K]

Put this in a new column in the query grid:

---------------------------------------
Field: IIf([Forms]![Open_Form]![CLAMT_BET] Is Null, True, [Tbl_MainWeekly].[Credit limit] Between [Forms]![Open_Form]![CLAMT_BET] And [Forms]![Open_Form]![CLAMT_and])

Show: uncheck

Criteria: True
---------------------------------------
.

 

[DanSmith]

Hi Jon K,

PERFECT

It is working like a charme......

thank you very very much

Have a nice day

Cheers!

Dan