I have created an append query and I am having a problem with the
format of the number column when it appends.  For example.  4.5 appends
as 4,a value of .5 appends as 0. I have adjusted the append query to
standard format three decimal places and have done the same for the
field that is being appended to in the table but nothing has worked.
The strange thing is that when I run the append query as a select
query, it is performing exactly as I have specified.  4.5 shows up as
4.500.  Any thoughts or suggestions would be much appreciated as I have
been battling this for a while.

Thanks