IIf function issue 1

[mmaginniss]

Hi-

I am having issues with the IIf function. What I am trying to do is use multiple conditions within an IIf function. At first, I created a calculated field with the following expression:

Sort: IIf([ProjectManager] Is Null,1,0)

This worked fine, giving null values a value of 1, and non-null values a value of 0, which I then used to sort my report. Of course, now I want to sort "None" strings as well. So, when I tried the following calculated field it didn't work:

Sort: IIf([ProjectManager] Is Null Or "None",1,0)

Any ideas how I could sort both field values of Is Null Or None with this function?

Thx.

 

[Golom]

You need explicit comparisons

   Sort: IIf(IsNull([ProjectManager]) Or [ProjectManager] = "None",1,0)

 

[Blorf]

You are almost there. Try

Sort: IIf([ProjectManager] Is Null Or [ProjectManager] = "None",1,0)




Ascii dumb question, get a dumb Ansi