How do I stop access from rounding Number Fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that records the Weights of various deliveries. For some
reason Access is rounding the deliveries that are not whole numbers, so
instead of 4.5 it shows 4 etc.

The field is a long integer field with a fixed format and decimal places set
to 2. I have tried other number formats and they all do the same thing.

How can I turn this "Feature" off?
 
The Long field type round the number, so is Integer.
Change the field type to Double or single, they will keep the decimal places
 
An integer (by definition) has no decimals. An integer is a whole number.
Change the field from integer to one of the many formats that supports
decimal places. Single is a good one. Note, it is the FIELD SIZE you want
to change, not the DATA TYPE.
 
Thanks To the Guys who Answered me. They were spot on, I changed the field
size to double and it now works like a charm :D
Nicole
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round Up a Decimal 6
Rounding for Number Data Type 2
Preventing rounding numbers to nearest dollar 2
Rounding Numbers 2
Stop Rounding in Forms 2
How do I stop Access from rounding Numeric Fields? 2
Found a Bug or Error in Access 2002-2003 Round Function 3
Form Combo incorrectly rounding 1

Back
Top