Access 2002

A

Anette

Hi!
Our Problem:
Decimals are truncated to one decimal when a calculation
in the "Heading"-field is made. The problem appears when
using the function sum. The formula reads: Ton:Summa
([KG]/1000).

Examples:

Calculation XP Expected result

30 divided by 1000 0 0,030

543 divided by 1000 0,5 0,543
Thanks
Anette
 
R

Rob Schneider

Perhaps try using the format function to specify the number of digits
you expect?

Hope this is useful to you. Let us know.

rms
 
Top