Append query dropping decimals

[thedanch]

Hi,
I've got an append query, and the target field is set as a Double, but I'm still losing decimals when I run it (only appearance wise though... there's a related calc, and it's treating it as the proper number).

Any suggestions?



Thanks

[orange]

Perhaps you could give an example to help us visualize the situation.
If it's only appearance, seems there is a format or default issue.

[thedanch]

The field size is double, format is general number, decimal places = auto, and no default value.
It's populated by a query that takes a an hourly rate (Currency) x a number of hours (Double) x ([Percent amount] x 100).

I'm wondering if it's just inconsistency with the fields, and whether they should just all be changed to doubles, maybe?