Friday, February 29, 2008

Single, Double Comparison Accuracy

Understanding problems with single precision and double precision can get you unstuck. Here is description of the problem all be it from a vb.net perspective.

Visual Studio Magazine Online | On VB: Maximize Comparison Accuracy

Personnaly the biggest problem in Access with single precision fields occurs when you use Sum or Avg in group by queries. The results generally come up with a figure that has some weird significant figures. The solution in this case involves changing the field from single precision to double precision. This will increase the table size by 4bytes*no_of_rows which can prove significant in large tables.

Garry Robinson

1 comment:

逆円助 said...

さあ、今夏も新たな出会いを経験してみませんか?当サイトは円助交際の逆、つまり女性が男性を円助する『逆円助交際』を提供します。逆円交際を未経験の方でも気軽に遊べる大人のマッチングシステムです。年齢上限・容姿・経験一切問いません。男性の方は無料で登録して頂けます。貴方も新たな出会いを経験してみませんか