[MS_AccessPros] Re: Expression Builder Frustrations with IIF statement

 

Rohn

First, make sure the control name is not CorrectiveActionTaken as that would cause a circular reference.

Next, CorrectiveActionTaken could be null so check for that as well.

=IIf(Len([CorrectiveActionTaken]& "")<>0,"X","Not Complete")

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

--- In MS_Access_Professionals@yahoogroups.com, "Rohn" <reverson@...> wrote:
>
> 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 (2)

Recent Activity:

• New Members 4
• New Files 2

Visit Your Group

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

.

__,_._,___