Formatting a calculated field

[Bradex]

I have used the following expression to calculate BMI (Body-mass index): [Weight]/([Height]/100)^2

It works, however, it creates the value with a large decimal e.g. 25.33333333. I want the decimal places to be limited to one e.g. 25.3.

I tried changing the 'Decimal places' under the 'Field properties' to 1. But it is not working.



What should I do?

[ranman256]

It should work.
if a query, rt-click the column, set the format, 0.00

if a form, set the box to FIXED ,and 2 decimals.

[Bradex]

The decimal places in field properties did not work at all.

I finally solved it in the datasheet view > Fields > Formatting > decrease decimals

[SuperAccessNinjas]

I'm pretty sure setting the format property for the field to standard in query design would work as well.

[Bradex]

@ranman256

Your method worked as well! Thanks!