decimal point problem

A

Andre C

Why is it that despite what I set in the properties of a field re
number of decimal points it never works. I get full decimals?

ACC
 
O

Ofer

The type of your field, if it long or integer it will always round the
number, change it to double or single
 
P

peregenem

Andre said:
It was a calculated field based on a date. hence my problem with
decimal points.
Click to expand...

SELECT ROUND(0.25 * 1.609, 1) AS kms

SELECT CDATE(DATESERIAL(1990, 1, 1) * 1.2) AS strange_calc
 
Top