VBBRett
asked on
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Datatype=Number
Field Type=Single
Decimal places=2