Insert Query Changes Value on Table

[gillopes via AccessMonster.com]

Hi all!

I need help with a insert/add query that I created. It calculates well all
the fields I need, but when it inserts them into the destination table some
of the values/fields are rounded.

I need this particular field to have a lot of decimals.

I supposed that it could be some property of the destination table causing it,
but I even removed some of its dependences to avoid that problem and it
persists. The specific field is defined in both the add query and destination
table as a general number with 10 decimals, but I allways end up with a 5
decimal rounded figure in my table.

Any ideas?

Many thanks!

 

[NTC]

make sure the properties in the tables are correct

and make sure the physical size of your textboxes in forms/reports are
clearly wide enough to accommodate the total number size.....

make sure the textbox property is correct