Stop a number from rounding off

[dvannoy]

I am using a numeric field with the formula function..based on what the user puts into one field it will fill in the other field based on the formula. But how can I stop a number from rounding off.. eg. user types 1.3 the system will change that to 1

how can I stop this? should I not be using a numeric field??

Thanks dvannoy@onyxes.com

 

[Andel]

Probably the resulting field is in INT (Integer) type.

Andel
andel@barroga.net

http://andyb.8m.com

 

[dvannoy]

I changed the type to int. still when i type 1.3 it will round down to 1

anyone??? dvannoy@onyxes.com

 

[Andel]

Because it is an integer. That's why I told you to change to something else other than integer. Try decimal.

Andel
andel@barroga.net

http://andyb.8m.com

 

[Glitchbane]

SQL seems to hate doing math. However - the INT solution is the wrong direction. If you want it to keep the ".3" part of "1.3", you need to use a non-INT numeric field.
The NUMERIC datatype holds precision and scale. The books online will describe this better than I, so check there (look for the "Decimal and Numeric (T-SQL)" listing).
In short - the precision is for the digits on the left of the decimal point, the scale is for the digits on the right. If you define your field (or variable) as a NUMERIC(10,3), your "1.3" value would be look like "1.300".
If you're populating the field with a variable, make sure the variable is the same datatype.