tables and data types (Qualifiers)

[Leaner79]

Hi,
I have a table, i have set one of the fields as Integer.
I would like to be able to add > and < qualifiers with the numbers and not get an error message.

Thanks

 

[Remou]

I do not think you can use anything other than minus in a numeric field, however, you can do a few things with a text field. For example:
Eval("20 " & Me.[txtText])
Would evaluate to -1 or 0 depending on txtText.