?
Solved

Access 2007 auto rounding up number in table

Posted on 2008-10-14
2
Medium Priority
?
2,462 Views
Last Modified: 2013-11-29
i have a field in a table that is set to the Number data type, how can i stop it from rounding up when i enter 1.5 as the number?

the field size is set to Integer and the decimal places property is set to 1
0
Comment
Question by:TSTechNA
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 22719026
Integer = Whole Number

You need to use Double.
0
 

Author Comment

by:TSTechNA
ID: 22720460
thank you
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

568 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