Iif (1 Viewer)

[cruzpatas]

I have a unbound text that I want to update to 20 when a field onte hform is >6 but = 0 when the field is <=6. Here is my IIF statement in the control source: IIF([Pitch]>6 OR [Pitch]<=6,"20","0"). No matter what Pitch equals the box keeps updating to 20. Why??

 

[Brianwarnock]

IIF([Pitch]>6,20,0)

You have 2 conditions in the criteria that cover all values, the " round the values will make them text ,is that intentional?

Brian

 

[pbaldy]

Your test is basically "if pitch is greater than 6 or less than or equal to 6 then..." Any value will meet that test. Try

IIF([Pitch]>6,"20","0")

 

[pbaldy]

Dang slow fingers!

 

[cruzpatas]

Great Job!!! I was a little off there with what I was trying to do. I seem to have mad a simple thing very complicated.