On Wed, 20 Jan 2010 08:59:44 -0800, "Jeff Boyce"
wrote:

Tom

I misunderstood. I thought the "Single" data type was one that offered
considerably more precision than "Currency".

Well... apples and oranges.

Single is a 16-bit floating point number, which provides approximately 7
digits of precision, with an exponent numbers up to about 10^37. So you could
have 12345670000000000 but it would be indistinguishable from
12345670100000000 (because the 1 is lost in the roundoff error).

Currency is a scaled huge integer, with exactly four decimal places and a
range into the trillions. It doesn't have roundoff error but you can't store
10^37 in it either.
--

John W. Vinson [MVP]