IIf Help!!!

[Fia]

How can I use an IIf function if I wan't to have 3 diffrent answers.
I'll will try to explain whet I mean.

If the value is neither True or False then I want to give the value of Ord
back.
I can't use the code below, because if Ord is another value than True or
False for example a string, "Hej", I'll get 0 back from the IIf-function. I
know I can use an if and else statement, but not in this case.
IIf(Ord=True,-1,0)

Please help

Fia

 

[Guest]

Use a nested IIF as below to return -1 if true, 0 if false or 2 if neither
true nor false
IIf(Ord=True,-1,IIf(Ord=False,0,2))

 

[John Vinson]

How can I use an IIf function if I wan't to have 3 diffrent answers.
I'll will try to explain whet I mean.

If the value is neither True or False then I want to give the value of Ord
back.
I can't use the code below, because if Ord is another value than True or
False for example a string, "Hej", I'll get 0 back from the IIf-function. I
know I can use an if and else statement, but not in this case.
IIf(Ord=True,-1,0)

What's the datatype of Ord? If it's an Access Yes/No field then True
(-1) and False (0) are the only values that it CAN have!

John W. Vinson[MVP]