Combine Iif calculations in one line...

[srburk]

How would I combine the following into one field in a query?

IIf([KEY]="SA",[T - Pro]![SA])
IIf([KEY]="SB",[T - Pro]![SB])
IIf([KEY]="SC",[T - Pro]![SC])
IIf([KEY]="SD",[T - Pro]![SD])
IIf([KEY]="SE",[T - Pro]![SE])

In other words, if KEY says SA then it will result with the data in SA. If KEY says SB then it will result with the data in SB, etc...