Cryptocurrency format help

[Timaxusa]

Hi all. Looking for help on handling cryptocurrency format in access. Having a hard time converting properly and calculate all balances. Cryptocurrency has 8 decimal digit and I am importing from exchange as string and they all different lenght depending on value. How can I get all numbers show with 8 decimal digits correctly so I can perform calculation with them afterwards? now if I have one number 0.000001 and another 0.00000004 for examlbe I get infinite number. Thank you

[Timaxusa]

I tried Format(MyValue,"#.########") and it gave me number with 8 decimals but 1.16911472 - 1.17839300 still gives me -9.27827999999997E-03. What am I missing here?

[June7]

Why don't you use Format() on the expression?

[Timaxusa]

Format did not help... I end up using Round(MyField, 8). Not sure if this was messing with exact calculations though

[June7]

I tested Format and it did work for me. I thought about Round.

Round function uses even/odd (banker's rounding). Format does not.

[ssanfu]

Maybe this example will help you?
The fields in the table - dblCrypto1 and dblCrypto2 - are Number types (doubles)
and the fields in the table - txtCrypto1 and txtCrypto2 - are Text types.

The calculations are done in the query.