IF Syntax error 2

[acct98]

Can someone tell me what's wrong with the syntax error below?


x
21% =IF(x >1 or <.85,&quot;yes&quot;,&quot;now&quot

 

[oharab]

21% =iIF(x >1 or <.85,&quot;yes&quot;,&quot;now&quot ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[acct98]

Try that function -- I dont think it will work because of the &quot;or&quot;.

 

[oharab]

Sorry, didn't notice the or.

IIF(x >1,&quot;yes&quot;,iif(x<.85)&quot;yes&quot;,&quot;now&quot)

----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[acct98]

Ben,

Unfortunately that did not work either.

 

[RacerGirl117]

Where are you putting this statement? Query or VBA? If in a query you do need two I's in the IF. And you can have Or statements in either place as far as I know.

Jessica Morgan
Fire Fighter Sales & Service Co.

 

[bev]

I think you need:

21% =iIF((x > 1 or x < .85),&quot;yes&quot;,&quot;now&quot

Bev

 

[acct98]

Thanks Bev.

I tried the if and syntax in excel and got it to work but it would not work in Access. Anyway thanks you suggestion worked perfect.

 

[oharab]

Bugger, I missed out a comma!
IIF(x >1,&quot;yes&quot;,iif(x<.85),&quot;yes&quot;,&quot;now&quot) would work, but so does Bevs!

B ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------