Multiple IIF Statement Help 1

[ecugrad]

Need a little help on a IFF Statment: I'm trying to use the below, but I thing I have it formatted wrong. Any help would be appreciated.



MType:IIF(([ProbEnd]) between #4/16/06# and #5/15/06#,1,4)OR
IIF(([ProbEnd]) between #5/16/06# and #6/15/06#,2,4)OR
IIF(([ProbEnd]) between #6/16/06# and #7/15/06#,3,4)

Thanks,
Mike

 

[rjoubert]

Try nesting your IIF statements...

IIF(([ProbEnd]) between #4/16/06# and #5/15/06#,1,IIF(([ProbEnd]) between #5/16/06# and #6/15/06#,2,IIF(([ProbEnd]) between #6/16/06# and #7/15/06#,3,4)))

 

[Wendysway]

I just used your answer to adapt my multiple-criteria from list box query. I've been looking for an answer to my 'missing bracket placement' for days now. THANK YOU SO MUCH FOR THIS INFORMATION!!!