Solved

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

Posted on 2009-04-06
2
269 Views
Last Modified: 2012-05-06
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
Comment
Question by:VBBRett
2 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 24077953
Hi VBBRett,

Change the datatype of the field in the table to Currency


Good Luck!

Gary
0
 
LVL 6

Expert Comment

by:AHMKC1
ID: 24085453
try following
Datatype=Number
Field Type=Single
Decimal places=2
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now