访问 SQL 编辑器 - "You may have entered an operand without an operator"

Question

我在JET/Access SQL方面非常糟糕，这让我很沮丧。在输入下面的代码时，我遇到了上面提到的错误，我不明白为什么-这基本上只是一个很大的IIf/then语句。它似乎突出了"PB"部分，如果这有任何帮助的话：

REQUIREMENT_TYPE_DESCRIPTION: IIf([REQUIREMENT_TYPE]="01","Warehouse Sales Orders",IIf([REQUIREMENT_TYPE]="04","Warehouse Sales Orders",IIf([REQUIREMENT_TYPE]="TB","Warehouse Sales Orders",IIf([REQUIREMENT_TYPE]="KE","Dedicated Sales Orders",IIf([bal]=0,"Warehouse Sales Orders",
IIf([REQUIREMENT_CATEGORY] = “A60380029”, "Warehouse Sales Orders,
IIf([REQUIREMENT_CATEGORY] = “A60380021”, “Warehouse Sales Orders,
IIf([REQUIREMENT_CATEGORY] =  “A60380020”, “Warehouse Sales Orders,
IIf([REQUIREMENT_CATEGORY] =  “A60380007”, “Warehouse Sales Orders,
IIf([REQUIREMENT_CATEGORY] =  “A60380001”, “Warehouse Sales Orders,
IIf([REQUIREMENT_TYPE]="PB","Forecast","Excess")))))))))))

Answer 1

在评论中应用建议，请考虑：

REQUIREMENT_TYPE_DESCRIPTION: Switch([REQUIREMENT_TYPE] IN("01","04","TB") OR [bal]=0 OR
[REQUIREMENT_CATEGORY] IN("A60380029","A60380021","A60380020","A60380007","A60380001"),"Warehouse Sales Orders",
[REQUIREMENT_TYPE]="KE","Dedicated Sales Orders",
[REQUIREMENT_TYPE]="PB","Forecast", 
TRUE,"Excess")