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.