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.

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.

here is a screenshot of my design view

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

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.