[MS_AccessPros] Expression Builder Frustrations with IIF statement

 

Thanks in advance!

On an existing report. I would like to add an identifier, instead of picking the Field from the Control Source I want to add an expression if the field has data; place an X on the report or if field is blank/null place a statement "Not Complete".

I have tried: =IIf(([CorrectiveActionTaken]=""),"X","Not Complete") but each variation I attempt I get #Type! or #Name or some other error. Do you know what I am doing wrong??

I am using Access 2010.

Thank you, Rohn

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___