Office中国论坛/Access中国论坛

标题: 为什么在生成表查询中输入13个及以上的IIF会出现错误 [打印本页]

作者: u2u2u2 时间: 2003-2-8 08:58
标题: 为什么在生成表查询中输入13个及以上的IIF会出现错误
我在一个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 时间: 2003-2-8 19:10
我晕！真的是13个就出错吗？看来鬼佬就是迷信。
你这种情况可以做一个自定义函数，用if...else...来进行处理。

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)