Number Round Off

  • Thread starter Thread starter Elijah
  • Start date Start date
E

Elijah

Why is it that the number I copied from excel to my
tables in access are rounding off?

Example : 79.85 (from Excel) -> 80.00 (in Access)

What Field Size should I use so that the figure won't
round off?

Thanks!
 
I would suggest the Currency data type.
If you don't want to see the $ symbol, change the Format property to
Standard. You might also want to set the Decimal Places property to 2.

Regards,
Andreas
 
Thanks!
-----Original Message-----
I would suggest the Currency data type.
If you don't want to see the $ symbol, change the Format property to
Standard. You might also want to set the Decimal Places property to 2.

Regards,
Andreas



.
Click to expand...
 
Back
Top