Dont want a calculation to round its result

[twalsh]

I have an update query that is calculating a field based on other criteria in
the table. The calculation works ok, except it round the result. in this kind
of calculation there is a big differnce between 4.4 and just 4. I tried Val
and CCur and CDbl as well as formatting the fields a billion different ways.

any thoughts?

 

[fredg]

I have an update query that is calculating a field based on other criteria in
the table. The calculation works ok, except it round the result. in this kind
of calculation there is a big differnce between 4.4 and just 4. I tried Val
and CCur and CDbl as well as formatting the fields a billion different ways.

any thoughts?

What is the calculation?
What is the Datatype and FieldSize of the field being updated?
If the Field's Datatype is Number and the FieldSize is Long Integer or
Integer, then it will NOT accept a decimal value.
Either change the Datatype to Currency or change the FieldSize to
Double.
Be aware that Single and Double FieldSize values are approximate, not
precise.

 

[twalsh]

Wow, That was a billion times simpler than i was thinking it would be! thanks!