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

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!
VBBRettAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tbsgadiConnect With a Mentor Commented:
Hi VBBRett,

Change the datatype of the field in the table to Currency


Good Luck!

Gary
0
 
AHMKC1Commented:
try following
Datatype=Number
Field Type=Single
Decimal places=2
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.