decimals

S

Sam

I created a Query and in the price column I mutiplied it by 1.08 which gave
me a decimal along with the number. I want to drop the decimals but not have
it round up or down.
 
J

John Spencer

That is unclear as to the desired result. Can you post an example or two
with the start value and the desired result?

1.08 * 1 = 1.08 result desired is 108 or 1 or ???
 
J

Jerry Whittle

Fixed: Fix([Price] * 1.08 )

But if you are dropping the decimals, you are rounding down. Do you actually
want to keep the calculation but just not display the decimals?
 
S

Sam

Yes I want ot keep the calculation and just not show the decimals or keep the
caculation anf make all the decimals .00

Jerry Whittle said:
Fixed: Fix([Price] * 1.08 )

But if you are dropping the decimals, you are rounding down. Do you actually
want to keep the calculation but just not display the decimals?
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Sam said:
I created a Query and in the price column I mutiplied it by 1.08 which gave
me a decimal along with the number. I want to drop the decimals but not have
it round up or down.
Click to expand...
Click to expand...
 
J

John Vinson

Yes I want ot keep the calculation and just not show the decimals or keep the
caculation anf make all the decimals .00
Click to expand...

Those are two quite different and contradictory requirements. You'll
get DIFFERENT RESULTS.

To simply not display the number, use a Format property of "#."; to
truncate the result to discard any fractional portion (e.g. 3.99 ->
3.00) use Fix() as suggested. Of course, 3.99 is not equal to 3.00 so
you'll need to discuss the total sales figures with the nice man from
the state sales tax authority...

John W. Vinson[MVP]
 
Top