IIF Condition

  • Thread starter Thread starter Pinacle
  • Start date Start date
P

Pinacle

What is wrong with my iif condition below.

=IIF([text87]< 0,"0",[text87])

Access is giving me the following error message.

You omitted an operand or operator , You entered an invalid character or
comma, or you entered text without surrounding it in quotation marks. Please
help me find the problem.

Thanks.
 
Is the value in text87 a number type or is it text that consists of numbers.
You can try the following variants to see if they work.

=IIF([text87]< "0","0",[text87])

or

=IIF(Val([text87])< 0,"0",[text87])

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Hi John,
I have tried both options but it is still throwing that error message.



John Spencer said:
Is the value in text87 a number type or is it text that consists of numbers.
You can try the following variants to see if they work.

=IIF([text87]< "0","0",[text87])

or

=IIF(Val([text87])< 0,"0",[text87])

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
What is wrong with my iif condition below.

=IIF([text87]< 0,"0",[text87])

Access is giving me the following error message.

You omitted an operand or operator , You entered an invalid character or
comma, or you entered text without surrounding it in quotation marks. Please
help me find the problem.

Thanks.
Click to expand...
.
Click to expand...
 
Where are you trying to use this?
Is this the source for a control?
What is the name of the control that this is the source for?

Is Text87 a field or is it the name of a control?



John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Hi John,
I have tried both options but it is still throwing that error message.



John Spencer said:
Is the value in text87 a number type or is it text that consists of numbers.
You can try the following variants to see if they work.

=IIF([text87]< "0","0",[text87])

or

=IIF(Val([text87])< 0,"0",[text87])

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
What is wrong with my iif condition below.

=IIF([text87]< 0,"0",[text87])

Access is giving me the following error message.

You omitted an operand or operator , You entered an invalid character or
comma, or you entered text without surrounding it in quotation marks. Please
help me find the problem.

Thanks.
Click to expand...
.
Click to expand...
Click to expand...
 
Try ; instead of , !!!

Sometimes in the query editor access needs ; but in sql it is , again.
 
It worked...Thanks alot. Actually this happened because of my language
settings..my list seperator was changed to ';' insead of ','.

Thanks again.
 
Back
Top