MS Access - can't deal with recurring numbers?

[Rik_StHelens]

I have a query which does some calculations.

It is limited to 1 decimal place, and this works fine.

However, when it returns a recurring number, it is not limited to 1 decimal place.

E.G. 7.78156765 rounds up to 7.8

7.33333333 displays as 7.333333334

Is this a bug or is there something else I need to do to limit this behaviour?

 

[namliam]

you can use the format of the column to display only a limited number of decimals
Or use round to 'fix' it?

 

[boblarson]

There's nothing wrong with Access in that regard. If you don't want rounding to occur then use the DECIMAL type of number with SCALE set to 1.