Jumat, 03 Agustus 2012

[MS_AccessPros] Re: Expression Builder Frustrations with IIF statement

 

Rohn

CorrectiveActionTaken is a field in the form's record source, right? It has to be included even if you don't use it directly on the form.

And you spelled it exactly like it is in the table, right? Check the table in design view to make sure. The query might be showing the display name if that field has one.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Rohn" <reverson@...> wrote:
>
> Thanks for the reply Bill,
>
> Control name is Corrective Action Taken. I used the:
> =IIf(Len([CorrectiveActionTaken]& "")<>0,"X","Not Complete")
>
> but I still get the #Type! error? Could I have somethings else wrong?
>
> Thanks again, Rohn
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > 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
> > >
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar