I need to round the decimal portion on a field. When I use the ROUND instruction for a field, it rounds the integer portion. For example: 2.589 , with the instruction the result is 3, and I need it to be 2.6 Please tell how can I do it.
I need to round the decimal portion on a field. When I use the ROUND instruction for a field, it rounds the integer portion. For example: 2.589 , with the instruction the result is 3, and I need it to be 2.6 Please tell how can I do it.
admaldo,
Round has two arguments; the first is the value to rounbd, the second is the precision to round to. You need something like:
Round([SomeField], 1)
That will round to one decimal place.