I have a variety of number fields that are populated as a result of an AUTO ENTRY calculation. The results often times have a decimal somewhere in them.

These fields are formatted to read as whole integers.

3.4 displays as 3

5.4 displays as 5

The sum of 3.3 + 5.3 currently displays as 9

I would like it to display as 8.

(I would also like to have the mathematical result = 8)

[color:red]Is there a way to make the values always round up or down at the half-point & present the result as a true integer?

What I would like is:

5.4 = 5

5.6 = 6

5 + 6 = 11

Any ideas?

Thanks,

Jarvis

You can display a field in many ways, but this has no effect on the value in the field. You could either include rounding in your original auto-entered calculation, or use:

Round ( Field 1 ; 0 ) + Round ( Field 2 ; 0 )

for the sum calculation.

Thanks Comment, you helped a lot!

Jarvis