[AccessD] Puzzling error msg? <Invalid precision for decimal data type.>

Gustav Brock gustav at cactus.dk
Wed Feb 19 03:31:01 CST 2003


Hi Michael

You are into deep sh.t here ...
Val() is for converting a numeric string to a numeric (a Long).

What you probably need is to convert the decimal output of CDbl() to a
string. Str() is for this. And CDbl() is hardly needed for anything as
Fix() returns a numeric.

Thus, I guess you should replace Val(CDbl(Fix(..)/10)) with Str(Fix(..)/10).

/gustav

> Hey I'm getting desperate :-)
> I might try the Val inside the cDbl...




More information about the AccessD mailing list