[AccessD] Rounding Error - A2K

Gustav Brock Gustav at cactus.dk
Thu Dec 10 03:21:42 CST 2009


Hi Reuben

If they are singles, store them as such. Nothing wrong with that.
Problems occur only when you start calculating with singles without converting them to a higher (double) or true (currency) precision data type.

/gustav


>>> accessd at gfconsultants.com 10-12-2009 03:54 >>>
Still another question...

Using the BEU I am creating new factor fields as double and using update SQL
placing the factors into the new fields.
The problem is they get placed in the new double fields with about 20
decimals.

Is there a way to insert the factors into the new double fields with just
the appropriate 6 decimals?

Reuben Cummings
GFC, LLC
812.523.1017





More information about the AccessD mailing list