vinculated table from sqql server200 into access 97, problem with numeric data

[Luis Ernesto Aguayo]

I have a table in Sql Server 2000 with a numeric field, actually float.

I use this table in an access 97 application, when trying to insert rounded
data I receive an error talking something like "decimal precision it's too
small yo receive the numeric value you tried to insert"

The code its:

INSERT INTO dbo_Celp (ValorTotal)
SELECT val(format(CxCH.Cantidad*CxCH.Valor,"############")) AS ValorTotal
FROM xxx
WHERE ...

Any idea?

Muchas Gracias

Luis Aguayo