Please Help! The Expression you entered is too complex

M

MrsTurner

Joined
Oct 5, 2012
Messages
1
Reaction score
0
Hi All,

I'm new to the forum and considered myself quite the novice when it comes to expression writing in Access. I have tried to add one more IIf statement to the following expression and when I do I receive the message "the expression you entered is too complex". Please let me know what I should do.

Universal_Product: IIf([Universal Product] Like "IJ-80","IJ8090110",IIf([Universal Product] Like "IJ-90","IJ8090110",IIf([Universal Product] Like "IJ-110","IJ8090110",IIf([Universal Product] Like "IS-330","IS300",IIf([Universal Product] Like "IS-350","IS300",IIf([Universal Product] Like "IS-420","IS400",IIf([Universal Product] Like "IS-440","IS400",IIf([Universal Product] Like "IS-460","IS400",IIf([Universal Product] Like "IS-480","IS400",IIf([Universal Product] Like "DS-1000","DS10001200",IIf([Universal Product] Like "DS-1200","DS10001200",IIf([Universal Product] Like "DS-100","DS100140",IIf([Universal Product] Like "DS-140","DS100140",IIf([Universal Product] Like "DS-62","DS6263",IIf([Universal Product] Like “DS-63”,”DS6263”,[Universal Product]))))))))))))))


Any help would be appreciated as this has began to give me a headache
 
Back
Top