• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

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!
0
VBBRett
Asked:
VBBRett
1 Solution
 
tbsgadiCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now