Appending decimal datatypes

C

cheeky

I have a form that has a few calculated controls with decimal datatypes, that
are referenced from a separate form. ie they tally tonnes, ore grade, and
ore tonnes based on the previous 2 values, and it is necessary to record
these to 4-5 decimal places. However, when I use an append query to append
those values into a table, the records become integers.
How can I append a value, ensuring it retains it's decimal values?
 
T

tina

to store decimal values, the datatype of the field(s) in the table must be
set to Single or Double.

hth
 
Top