Filter Property of TTables

[jhames]

Every time I try to add a filter that compares the value of one field to another field, I get this error that says " Filter not terminated properly".
Example: 'Quantity in Stock' < 'Reorder Level'
What am I doing wrong?

 

[StevenK]

The Filter is a String - the error message sounds as if you're not entering a string correctly.
If you're comparing 2 field values - just use something like Field1 < Field2 - I don't think there's any call for the single quote marks if you're using them.
If this isn't the problem then please indicate the exact syntax of the filter so we can make further suggestions.
Hope this helps ....
Steve

 

[jhames]

Steve,

Thanks for the response. You were correct on the quote marks but it still did not work. However, the answer was on the bottom line of the help page concerning filters. The property does not allow comparisons of fields in local tables. In my haste, I just overlooked this statement.

John