CharlieKamer
MIS
I am using query on a linked DB2 table and I would like to sum a field which is defined in DB2 as DECIMAL (6.2).
The problem is when I attempt to run the query, I get an error
"The decimal fields precision is too small to accept the numeric you attempted to add."
It works fine if I do a Report or Form, but using query with a linked table I cannot change the attributes of the field.
Is this a feature or a problem with Access?
The problem is when I attempt to run the query, I get an error
"The decimal fields precision is too small to accept the numeric you attempted to add."
It works fine if I do a Report or Form, but using query with a linked table I cannot change the attributes of the field.
Is this a feature or a problem with Access?