take operator from table to perform calculation

[kpal292]

I have a table that displays a number.
I need to update a field in the same table with a category that corresponds to the result of the operation result.

Example:
Data Table
Client Code = 123
Material = 100
Field CM1 = -10
Field Category = null

Exception Table
Client Code = 123
Material = 100
Low Range = -15
Low Range Criteria = '<'
High Range = -5
High Range Criteria = '>'

I need to compare the Data.cm1 value to the exception table low range and then again to the high range, if the cm1 value is within the range, field 'category' of the data table is updated with 'Rules Database' and if not then Category is left blank or will have some other value.

How can I make this comparison?

 

[PHV]

Have a look at the Application.Eval method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886