Format changes

[nicknameClair]

I have a table with an amount field. I have set the format to be
Double;Standard;decimal 2. Everything is fine in the actual table, but
when I create a sum query and then enter on each record in the amount field,
some of the numbers change. I have set the format also in the query. e.g.
25.20 displays, but when I enter, it shows 25.2. Or some will show
3,200.00 but when I enter it will show 3200.00. It's not consistant, some
are ok and some are wrong. Would appreciate any help. Thanks, C

 

[Jeff Boyce]

First of all, if you will only ever need no more than 4 decimal places of
accuracy (and I'm assuming "amount" is dollars & cents), don't use the
Double data-type. Access stores Doubles as binary, and makes what humans
might consider rounding/display errors.

Instead, use the Currency data type.

Next, what Access stores and what Access DISPLAYS are not necessarily the
same. Don't confuse the display formatting with the underlying data type.
Where you are looking can make a difference in what you see.

My suggestion -- store as Currency, display (format) as Currency w/ 2
decimal places.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/