Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

=IIf EXPRESSION - ERROR

Status
Not open for further replies.
kinselas

kinselas

IS-IT--Management
Aug 4, 2002
60
AU
My following expression shows an error
Please help....
If the score is 0 then "low" , 2 and 3 is "Medium" and more than 3 is "High"
My code is
=IIf([PERFORMANCE1]<=0,&quot;LOW&quot;,IIf([PERFORMANCE1]>3,&quot;HIGH&quot;,&quot;MEDIUM&quot;))
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
4K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
&quot;There isn't enough memory to perform this operation...&quot; error after upgrading from Access
Replies
2
Views
532
Axworthy
Axworthy
DeRochier
  • Locked
  • Question
Subform triggers error: &quot;This expression is typed incorrectly...&quot;
Replies
3
Views
588
DeRochier
DeRochier
DB_Bowes
  • Locked
  • Question
Selection from Listbox to GoTo Record in Bound form Gives Error 2105
Replies
1
Views
391
DB_Bowes
DB_Bowes
bosk0
  • Locked
  • Question
Getting a syntax error in INSERT INTO statement 1
Replies
5
Views
478
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top