Decimal places (1 Viewer)

[edawson]

Hi all,

I want to but numbers with 2 decimal places in a field. I have the data type set to number in the desired field - yet when I copied and pasted the data over, all the numbers that had 2 decimal places lost them. The only number visible was the whole number. How can I make the numbers reatain their 2 decimal places?

Elliot

 

[Bat17]

Set the Field Size of the field to Double.

HTH

Peter

 

[willmarbrin]

Hi I have the same issue. I have a DB that receives data from a microsoft excel sheet via VB macro upload command(recordset). The command uploads all the data successfully however when I view the values, all my decimal places are gone and all are set into zeros after the period. Can somebody help me on this? Thanks!

 

[pbaldy]

What is the data type/size of the field in the table? If Integer or Long Integer, there's your problem.