<div>
try following <br />
Datatype=Number<br />
Field Type=Single<br />
Decimal places=2
</div>


try following
Datatype=Number
Field Type=Single
Decimal places=2

<div>
<div class="content wysiwyg-content">
I am trying to insert data into my Access database but for some reason, it is not working out. &nbsp;If I insert a value with two decimal places after the period, it shows up in the table as just a integer value number without the decimal values. &nbsp;I do have the column as a number and set to two decimal places, I am just wondering what the deal is. &nbsp;Please let me know. &nbsp;Thanks!
</div>
</div>


I am trying to insert data into my Access database but for some reason, it is not working out.  If I insert a value with two decimal places after the period, it shows up in the table as just a integer value number without the decimal values.  I do have the column as a number and set to two decimal places, I am just wondering what the deal is.  Please let me know.  Thanks!

Why does my Access DB number column show up as integers as opposed to currency type value?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.