possible to have an expression within an expression?

[sfgiantsdude]

Expr5: IIf((Expr4: [MCA_EPM_ISSUES]![QTR] & ‘Q’ & Right([MCA_EPM_ISSUES]![KP_YR_NB],2)) not in("3Q11","2Q11","1Q11","4Q10","3Q10","2Q10","1Q10 "),"TEST",Null)

Is it possible to create an if then statement for an embedded expression that you create within the if then statement? I'm trying to create an if then statement for a combination of two fields in a table to combine the quarter field and the year field so it looks like "4Q10".

Any help would be much appreciated!

[aytee111]

Yes I should think so, as long as the syntax is right. A few things right off the bat : Expr4 should not be there, it looks like you are mixing quotes, all quotes should be double or single (it looks as though the Q is in single quotes), there is an extra space in 1Q10.