Why does Summary Query generate rogue values?

[vwgolfman]

Hi,

A field in a table has the following properties...
DataType: Number
Field Size: Single

I have ONE record in the table and the value for the above field is 147319.7

When I display this record in a report by using a "Detail Query" the value for the field is correctly displayed as 147319.7

HOWEVER, if I use a "Summary Query" the value for the field is displayed as 147319.703125

There is only ONE record in the table so where has the 0.003125 come from?

Does anybody know?

 

[MStef]

In the table, click on this field, you have to see 147319.703125
How did you get this value ????

 

[vwgolfman]

Hi MStef.

When I check the field in Datasheet view, the value is 147319.7

After some reading it appears that the reason I am seeing rogue values is that the number is stored as a floating point number.
This means that it is stored approximately and not exactly.

 

[MStef]

Yes, it can be so.