query - if is true then add 30?

[mike_980]

Hi guys, probably an easy one today but not something ive ever done before!



Basically what I need making into an expression is "If shallow_soil = true then N_max + 30, If Shallow_soil = false then leave N_max alone"

[JoeM]

You have pretty much already written it yourself.
What is the data type of Shallow_soil?
Is it Boolean or String?

If it is Boolean, then:

MyCalc:IIF([Shallow_soil]=True,[N_max] + 30, [N_max])

If it is String, then:

MyCalc:IIF([Shallow_soil]="True",[N_max] + 30, [N_max])

[mike_980]

Works perfectly thanks alot! I knew the theory on how it would work but I couldn't get it to work for some reason, I don't think I had the brackets quite right (I can never get them right!)

Thanks again.

[JoeM]

If you field names do not have spaces in them, you usually do not need the square brackets. But it never hurts to add them.