Data Comparison

[lexsaint]

I have a field in a table containing data in this format; >=16, <=9,<4 and so forth. I need to compare the sum of a certain field to the above field.

Any ideas?

[Killer42]

I have a field in a table containing data in this format; >=16, <=9,<4 and so forth. I need to compare the sum of a certain field to the above field.

there may be ways to have an expression like this calculated dynamically, but failing that you might just have to bite the bullet and do it yourself.

If you think about it, it shouldn't be difficult to split up the comparison characters and the number, and then perform different checks based on the characters. For example

Select Case sComparisonType
  Case ">="
    Result = ( DataValue >= ReferenceValue )
  Case ">"
    Result = ( DataValue > ReferenceValue )
  ...