Property Sheet - not displaying Decimal Places

[Rison]

Hello all,



I'm hoping to get some help with a problem. I am generating the age in a query, and looking to limit the decimal place to 0 (for obvious reasons).

The query is this:
Age: (((Now()-[Client_DOB])/365.25))

It works fine, however it's showing the persons age with two numbers after a decimal place.
I have changed the property sheeet of the field to Format: Standard (and fixed, and a bunch of other stuff) however it doesn't show the 'Decimal Places' row below it. It goes straight to 'Input Mask'.

How do I change it, so it recognizes it at as number with decimal places?

Thanks in advance.

[JoeM]

You can use the ROUND function to get rid of the decimal portion, i.e.
Age: Round(((Now()-[Client_DOB])/365.25),0)