numeric fields

J

jenhj

Can anyone tell me why suddenly numeric fields in a very simple database have
started rounding up & rounding down - ie I enter 4.25 and it displays 4.00,
1.75 displays as 2.00. I tried every combination of decimal places, format
etc but nothing seems to stop it. I've never come across this prob before
and it's friving me nuts!!
 
A

Allen Browne

Open your table in design view.
Select the numeric field.
In the lower pane, change the Field Size from to Double.

The integer types can only store whole numbers.

The format and number of decimal places only affects how the number is
displayed, not how it is stored.
 

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

Don't want Access to round numbers to nearest integer. 1
Decimal Number 1
How do I stop Access from rounding Numeric Fields? 2
Stop Rounding in Forms 2
Left function 5
how do i solve the numeric field overflow problem? 1
Total is off by a couple of cents 4
VLOOKUP, a table with text and numerics 7

Top