(Msg. 1) Posted: Thu Jul 03, 2008 9:59 am
Post subject: 3 value expression Archived from groups: microsoft>public>access (more info?)
what is wrong with this expression????????
=IIf([GrandTotalPts]<90,"Coaching Opportunity","Successfully Meets
Requirements"), IIf([GrandTotalPts]>100,"Exceptional Service
Call","Successfully Meets Requirements")
I keep getting an error msg that the expression contains invalid syntax or I
need to enclose my text data in quotes and I have an invalid comma or missing
quotes.
(Msg. 2) Posted: Thu Jul 03, 2008 1:18 pm
Post subject: Re: 3 value expression [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=IIf([GrandTotalPts]<90,"Coaching Opportunity",
IIf([GrandTotalPts]>100,"Exceptional Service Call","Successfully Meets
Requirements"))
"switchboard help" <switchboardhelp.TakeThisOut@discussions.microsoft.com> wrote in
message news:8D19100E-5E06-411E-9185-C04108D4115F@microsoft.com...
> what is wrong with this expression????????
> =IIf([GrandTotalPts]<90,"Coaching Opportunity","Successfully Meets
> Requirements"), IIf([GrandTotalPts]>100,"Exceptional Service
> Call","Successfully Meets Requirements")
>
> I keep getting an error msg that the expression contains invalid syntax or
> I
> need to enclose my text data in quotes and I have an invalid comma or
> missing
> quotes.
>
> Probably the simplest thing but I cant' find it.
>
>
(Msg. 3) Posted: Sat Jul 05, 2008 1:52 am
Post subject: Re: 3 value expression [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
me gustaria conoceros mejor
"switchboard help" <switchboardhelp.TakeThisOut@discussions.microsoft.com> escribió en
el mensaje de noticias:8D19100E-5E06-411E-9185-C04108D4115F@microsoft.com...
> what is wrong with this expression????????
> =IIf([GrandTotalPts]<90,"Coaching Opportunity","Successfully Meets
> Requirements"), IIf([GrandTotalPts]>100,"Exceptional Service
> Call","Successfully Meets Requirements")
>
> I keep getting an error msg that the expression contains invalid syntax or
> I
> need to enclose my text data in quotes and I have an invalid comma or
> missing
> quotes.
>
> Probably the simplest thing but I cant' find it.
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other