Decimal question. Why doesn't this work.

[Spyder1000]

I've got two fields in a detail section:
CSI and Total

Now my table has data like this:
CSI: 2.625
Total: 16

Multiplying 2.625 x 16 actually equals 31.50. However my field returns 32. Even when I set the format to standard with 2 decimals it still returns 32.

Any ideas?

 

[THWatson]

Spyder1000
Isn't it the case that 2.625 x 16 = 42?

16 x 2 = 32
16 x .625 = 10

In any event, make sure that your table shows the data type as double and not Integer.

Tom