Text and Numbers in a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning values to text for calculation 0
Mixed Data Import from Excel 2
Determine if a number falls between two numeric fields (low/high) 2
Formatting a percent field 1
Format a percent field 1
And v. Or and Not Like for in two fields 5
Converting Text to Numeric Value 2
URGENT: non-numeric values in "number" fields 6

Back
Top