decimals

[Guest]

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.

 

[Guest]

New Field: Int([Price] * 1.08)

 

[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 ???

 

[Guest]

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?

 

[Guest]

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

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.

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.

 

[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

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]