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
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.