3 value expression

  • Thread starter switchboard help
  • Start date
S

switchboard help

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.
 
D

Douglas J. Steele

=IIf([GrandTotalPts]<90,"Coaching Opportunity",
IIf([GrandTotalPts]>100,"Exceptional Service Call","Successfully Meets
Requirements"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling all SQL gurus. 3
Format from 2 to 02 1
Same concept as If Statement. 5
Expression using Iif with dates 5
Query design view - commas being changed to pipe characters 4
Help on calculation 4
access 2003/2007 - problems with unwanted pipe character 0
Syntax error? 6

Top