iifs query returns -1

[Lifeseeker]

Hi there,

I am writing some iif conditional statements in one of my tables to assign new values in that table.

FP: IIf([cohort with status].[Intake Date] Between #04/01/2012# And #26/04/2012#,201201) Or IIf([cohort with status].[Intake Date] Between #27/04/2012# And #24/05/2012#,201202)

When I run it, I am getting some -1 values in the new column FP.

but if I get rid of the second IIF, then it works.

how do you combine multiple IIF statements in a query?

Any help is much appreciated.

 

[jdraw]

iif - the immediate iif Function has a defined syntax which you are Not really using.

see http://www.techonthenet.com/access/functions/advanced/iif.php

IIF(condition, statement for conditionTrue, statement for condition False)