Number Conversion

[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

 

[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