! Decimal Field Precision !

  • Thread starter Thread starter Wembly
  • Start date Start date
W

Wembly

Hi,

I can not figure out why when assigning a value to a table
(using DAO), that I get this error msg:

The decimal field's precision is too small to accept the
numeric you attempted to add.

The value that is being entered is 1 (dimmed as Double).
My table design has 18 for Precision, 18 for Scale, and 0
for Decimal Places.

Your help is greatly appreciated.

Wembly.
 
A Precision or 18, and 18 as the Scale (right of the decimal point), leaves
nothing to the left of the decimal, so 1 cannot be stored.

Perhaps you intended 18 places with 0 Scale?
 
By the way, Wembly, I've been meaning to say: though you're within your
rights, that thing you do with the exclamation points in the subjects of
all your posts is getting pretty old.
 
Back
Top