Hi all. I need the best way to apply multiple nested IIF statements in a field on a form. The following is the IIF statements:
Code:
IIF([sfrmCust].[Form]![DED]>0,IIF([Patcnt]*16<=1000,16*[Patcnt],1000),0)+
IIF([sfrmCust].[Form]![SWE]>0,IIF([Patcnt]*24<=1000, [Patcnt]*24,1000),0)+
IIF([sfrmCust].[Form]![PLI]>0,IIF([TPtcnt]*24*12<=10000, [TPtcnt]*24*12,10000),0)+
IIF([sfrmCust].[Form]![Loc]*(IIF([Fre]=”Wk”,52,IIF([Fre]=”BWK”,26,IIF([Fre]=”SM”,24,IIF([Fre]=”M”,12)*10+
RtR*IIF([Fre]=”Wk”,52,IIF([Fre]=”BWK”,26,IIF([Fre]=”SM”,24,IIF([Fre]=”M”,12)*1
Do you think it is too much to put in the control source in the field on the form? Or should I put this in a module. Not sure if it's correct. Seeking guidance please.