Stopping queries from rounding off

[Bee*]

I have two tables. Table1 has two monetary value fields (both set with auto decimal places) and table2 has one monetary field. Then I have an append query which appends all data from table1 to table2, except for the monetary fields which are added up and then appended into table2's single monetary field (which also has decimal places set to auto). The formula I use for this is as follows:

Total Value: [Gross Value]+[Adj'mt Value]

Problem is, the total figure appended to table2 is rounded off to the nearest integer, whilst still displaying decimal places (45.00, 201.00 etc). Is there some sort of variable to set in the query to stop it from rounding off the result of this formula?

Any help would be appreciated.

Thanks.

 

[Guus2005]

A few things: (both donts)
1-You shouldn't store process data.
2-Do you really have a quote in the name of the field?

Perhaps this works?

Total Value: cdbl([Gross Value])+cdbl([Adj'mt Value])

HTH