为什么在生成表查询中输入13个及以上的IIF会出现错误

u2u2u2

我在一个FIELD里输入
Type: IIf(Left([Dip],1)="B","BT1",IIf(Right([Dip],3)="BT4","BT4",iif(right([dip],4)="btr1","BTR1",IIf(Right([Dip],4)="iabt","IABT",IIf(Left([Dip],4)="MECH","MECHO",IIf(Left([Dip],1)="M","MBLT",IIf(Right([Dip],4)="MTS3","MBLT86",IIf(Right([Dip],4)="MTS5","MCELT",IIf(Right([Dip],4)="MTS6","MTS6",IIf(Right([Dip],4)="S7ET","UPD24A",IIf(Right([Dip],5)="S7ET1","UPD24B",IIf(Right([Dip],4)="tr1h","TR1H",IIf(Left([Dip],3)="RMX","REMUX",IIf(Left([dip],1)="r","R")))))))))))))
结果告诉我 THE EXPRESSION YOU ENTERED IS TOO COMPLEX，输入的表达式太复杂

Trynew

我晕！真的是13个就出错吗？看来鬼佬就是迷信。
你这种情况可以做一个自定义函数，用if...else...来进行处理。