I've got the following nested immediate IIF statement and it is giving me an error:
relatedtype: IIf(([rltd_type]="Advantage","A",[rltd_type]),IIf([rltd_type]="Classic","C",[rltd_type]),IIf([rlt...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20824262.html
Zones:
MS AccessDate Answered: 12/12/2003 Grade: A Views: 10
I have the following:
=IF(DATE="","OK",
IF(DATE<25,"MONDAY"
,IF(DATE<35,"TUESDAY",
IF(DATE<45,"WEDNESDAY
",IF(DATE<75,"THURSDAY"
,IF(DATE<88,"FRIDAY"
,IF(DATE<92,"SATURDAY"
,"WEEKEND"))...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23456152.html
Zones:
MS AccessDate Answered: 06/04/2008 Grade: A Views: 93
