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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expression You Enter is Too Complex - Help PLEASE 6
The expression you entered is too complex 3
Getting error: "The expression you entered is too complex" in quer 6
The expression you entered is too complex? 1
Control Source Expression is too Complex 5
The expression you entered is too complex 2
"The expression you entered is too complex" 1
Need help Refining a Macro & make more Robust. 2

Top