rounding problems

On Wed, 16 Sep 2009 10:17:10 -0700, "voodoo" wrote:

Thanks Gina,

That seemed to do the trick although I'm not sure why?

To get the number to show only one decimal I did have to change your
equation
from: =Int([YourField]*100)/100
to: =Int([YourField]*10)/10

PMFJI but...

54.9876543210 * 10 is 549.876543210

Int just takes the integer part, discarding (not rounding) the fraction, so
Int(54.9876543210*10) is 549.

Dividing that by 10 gives 54.9.
--

John W. Vinson [MVP]

THANK YOU THANK THANK YOU

I knew it was something simple.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"John W. Vinson" wrote in message
...
On Wed, 16 Sep 2009 10:17:10 -0700, "voodoo"
wrote:

Thanks Gina,

That seemed to do the trick although I'm not sure why?

To get the number to show only one decimal I did have to change your
equation
from: =Int([YourField]*100)/100
to: =Int([YourField]*10)/10

PMFJI but...

54.9876543210 * 10 is 549.876543210

Int just takes the integer part, discarding (not rounding) the fraction,
so
Int(54.9876543210*10) is 549.

Dividing that by 10 gives 54.9.
--

John W. Vinson [MVP]