IIF to do NOTHING if false.
Posted on 2004-11-16
this is pretty simple, or so I thought... I have a 2 text boxes with the following control source
I have 2 records in the report. One record has a date of 10/1/2003 the other 10/1/2004.
All I want to do is to have it evaluate and then set the boxes to the value as outlined in the IIF. The problem is that when it evaluates the expression for the second record, it finds it false and wipes out the value from the first record.
Is there any way to have the IIF do NOTHING if FALSE.....Absolutely nothing....I don't want the value to change. I will use the value later.
I have tried everything....I even tried SWITCH([Month]='10/1/2003',[SumOfYTD Life]).....It still evaluated and changed the value of the box.
please HELPPPP ME....