Scripting syntex inquiry for the "Specify Field Calculation" window.
At the “Specify field Calculation” window.
I tried entering the following conditions ….
Table::_FIELD1_ < .095 and > .105 or
Table::_FIELD2 _ < .095 and > .105 or
Table::_FIELD3_ < .095 and > .105 or
Table::_FIELD4_ < .095 and > .105 and
Table::_FIELDA_ = "TEST FAILED" or
Table::_FIELDB_ = "TEST FAILED" and
Table::_FIELDC_ = " TEST FAILED"
The message I get is “A number, text constant, field name, or “)” is expected here.”
The message points to the first “>” .
Thank you. Any suggestion is appreciated.
I also tried to identify the conditions above for fields 1-4 in the layout mode.. condtional formatting and wanted the field to be highlighted if the range was field < 0.095 and > 0.105. Conditional formatting just highlighted all fields. Is the range in conditional formatting limited to whole numbers only?