decimal not showing correctly in append query

N

naiveprogrammer

I have an append query that is not showing the cents in a number field. I
have the field set to Long Integer, Currency & 2 decimal places. I.e. $14.35
is round down to $14.00. $14.70 is rounding up $15.00. The table that I'm
pulling the info from to append shows the correct amount.

Any ideas?
 
Top