Merge two tables

[Guest]

I want to create a new question (óne of those questions with a green cross,
"query di accodamento" in Italian") to be able to merge some dat from two
different tables. This works fine as long as I do not want to merge the field
called "colli". Then Access tells me (In italian so I try to translate) "The
precision in the decimal field is to small to be able to accept the numerous
value you tried to add"

What do I have to do to continue?

/Andreas

 

[Jamie Collins]

Access tells me (In italian so I try to translate) "The
precision in the decimal field is to small to be able to accept the numerous
value you tried to add"

What do I have to do to continue?

Increase its precision?

To recreate the problem:

CREATE TABLE Test1 (
dec_col DECIMAL(4, 2) NOT NULL
);

INSERT INTO Test1 (dec_col)
VALUES (100);

-- fails with the error, 'The decimal field's precision is too small to
accept the numeric you attempted to add.'

With a scale of 2, the precision would have to be at least 5 to
accommodate the value 100 i.e. alter to DECIMAL(5, 2).

Jamie.

--