• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1578
  • Last Modified:

Stop access from rounding up

OK, so I **should** be able to stop this.....

How do I prevent Access 2000 from rounding 8.75 up to 9?  In the table, the field size is Double, format is General Number, decimal places 2.  The form based on that table, the format (for the field) is General Number, decimal places is 2.

If I enter the 8.75 directly into the table, it's fine, but when I put it in the form, it rounds up to 9.
0
dcurtis
Asked:
dcurtis
1 Solution
 
Alan WarrenCommented:
In the table design

FieldSize = double
Format = Fixed
DecimalPlaces = 2


hth
alan
0
 
dcurtisAuthor Commented:
Thanks
0
 
nmilmineCommented:
I would use

FieldSize = single
Format = standard
DecimalPlaces = 2


This would use half the size of a double and would use commas for values over 999
0
 
mr_chinchin25Commented:
definately agree with alan warren, you want format = fixed and decimal places = 2
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now