How do I stop access from rounding Number Fields?

N

Nicole Monchamp

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?
 
O

Ofer

The Long field type round the number, so is Integer.
Change the field type to Double or single, they will keep the decimal places
 
R

Rick B

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.
 
N

Nicole Monchamp

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
 

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

Paragraph numbering in Word 1
Finding the proper style field and the numbered paragraph value within the style 0
Stop Rounding in Forms 2
Rounding Numbers 2
Found a Bug or Error in Access 2002-2003 Round Function 3
Form Combo incorrectly rounding 1
How do I prevent a number from rounding in Access? 2
Mail Merge - displaying a conditional number of decimals 5

Top