AnsweredAssumed Answered

IIF expression for attribute assistant

Question asked by bhumphries_mgis on May 31, 2019
Latest reply on Jun 4, 2019 by bhumphries_mgis

I am trying to calculate a field using the attribute assistant using the Dynamic Value table. 


I want to check the MainHeading Field and if the value of the field falls in between two values Calculate Yes or NO 

If the value is between 166 and 195 I want the field to be populated with a Yes

If the value is not between those values I want to field the populated with a NO


Below is the what I have tried, but I keep getting the same results as YES for all values even the ones that are not in between the 166 and 195 range.

IIF([MainHeading] >= 166 & [MainHeading] <=195, "YES", "NO")


I am sure I have something wrong but I cannot figure it out.


I know someone on here can solve this.