access 365 field multiplication problems

Question

Goodmorning,

I'm new to the comunity, so nice to meet you.

I have a issue with the multiplication of a fileds in double precision in a query.

E.g.: [surface] = 0.0216;

   [face-number] = 1;

   => I need [result] = [surface] \* [face-number] =>  [result] = 0.0216 \* 1 => but [result] = 2,16000005602837E-02 not 0.0216.

After the moltiplication I must sum the [result] with other data to make a chemical formula and extract Ampere, therefore the surface value must be precise.

I've tried round() in several ways, but the result doesn't change.

How do i solve?

Thank you

Matteo Andreatta

Answer 1

This kind of impreceision is, unfortunately, a function of the imprecision inherent in numbers defined as double.

There is an alternative, which might work better for your calculations. You could define the number as Currency, instead of double. It is accurate to four decimals, which is what your example shows. If all of your values are accurate to 4 decimals or less, this datatype can reduce the imprecision of calculations based on it.

Answer 2

I've tried round() in several ways, but the result doesn't change.

Hi Matteo,

You could also use the Round function, giving the number of decimals, e.g.

result = Round(result,4)

Imb.

Answer 3

Thanks a lot @GroverParkGeorge

I'll try better, but trying a little, it works.