[AccessD] Data entry in table question

It's a question of precision.  There are limits on the precision of a
single, so a large enough number starts trimming from the right.  That's
why you need doubles for some things.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Thursday, July 23, 2009 1:59 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Data entry in table question

When I type a number with eight decimal places into a table with data
type of single the last digit changes when saved. What is happening?


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com