Text and Numbers in a field

L

Larry G.

I am entering data into my table, some of the data needs to be a semi
numerical value "< .50" and some of it would need to be a numerical value 3.76

Is there some way to enter some fields as text and some as numerical
depending on the value I type in?
 
A

Allen Browne

Put the operator into a separate field, so you have a Text field (probably a
drop-down list of valid operators) and a Number field.
 
Top