Dec 22 2005, 03:53 PM
I need to know how to get my quantities to quit rounding my decimals off. i have the number set to standard and also have decimal places set to two. My number shows two decimals, but it always sets them to 00. I have tried general numbers and everything. The only this that works is to set my number as currency and that is not what i want to do. Please help. And i have already check my window regional setting and they are fine.
Dec 22 2005, 03:56 PM
What kinds of quantities are you entering? What is the type of the field into which you are entering these quantities?
Edited by: fkegley on Thu Dec 22 15:56:40 EST 2005.
Dec 22 2005, 04:05 PM
here is a screenshot of my design view
Dec 22 2005, 04:39 PM
i just noticed that my attachment looks horrible. I am just entering regular numbers into a regular table like 1333.45 or something like that. After i would put in that number it would come out like this 1334.00. I do not want it to round off
Dec 22 2005, 06:37 PM
You used Number Data Type of Long Field Size that can only store whole-number values. In this case, if a decimal value is entered, Access will round it and store the rounded value, not what was entered.
Depending on your requirements, change the Data Type to Currency or retain the Data Type as Number but change the Field Size to Double / Single / Decimal.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here