Number Conversion

T

Tony Ramirez

Hello...

Would like to take the number 2 (from the source table) and convert it to
..02 for calculation within a form and a query. Thanks so much...you all
rock!!!

Tony
 
F

Fred

Assuming that:

"2" is merely an example, not the sole case
And that the desired conversion is to divide by 100
the "2" is in a field called "NumberSource"


The use the expression
=[NumberSource]/100

alternatively
=[NumberSource]*.01
 
Top