Access DATA Type ACCESS

[actuarygirl]

I have a calculated avg field in my query, but it's resulting in eight decimals. How can I change this to no decimals at all?

 

[goodfellow]

Hi actuarygirl,
You can use round function. You can choose how many decimals you want (including zero). Here's the usage.