Rounding problem

[ya5irha55an]

Hi All, I hope someone can help me with this odd little problem!

I have a query with 2 fields, one called 'list size', which contains 4 digit numbers, and another calculated field called 'list size per 100', which has the simple formula '[list size]\1000'. The problem is this field rounds the result down, so for example where the list size is 8979, the list size per 100 should be 8.98, but is giving me 8.00! How can I resolve this? I have tried setting the properties to different things but no luck.

 

[boblarson]

Did you make sure that the field is not set to Integer or Long Integer? You would need single, double, or decimal.

 

[ya5irha55an]

Yes, all fields are set to double- still no luck.

 

[Dennisk]

explicity cast the field as a floating point field using the type conversion function for single or double precision.

this is for single

CSng(expression)