Feild Data

  • Thread starter Thread starter AJOLSON
  • Start date Start date
A

AJOLSON

I am dividing two cells and the results are coming up in scientific format.
I can make it look in any format I wan. The problem is when I send it to a
mail merge it defaults back to the scientific format. I have tried sending
it to a function where it is sent back as a string data but when it goes into
the function it is going in as scientific format. .
Here is the example . the results of the calculation is -.10, that is
what I want to see, However at the root table it is coming up as -9.23432222
e2. So changing it to text gives me-9.23432222 e2 and not is -.10. So how
to I get it to show as is -.10 in the field as string data?
 
Rather than check whether the value is equal to -.10, check whether the
difference between the value and -.10 is "close" to zero:

In other words, rather than

WHERE MyValue = -.10

use something like

WHERE Abs(MyValue + .10) < 0.001

(adjust the 0.001 until you get a threshold value that works for you)
 
Back
Top