Cant eliminate decimals in a query

[SoloUser]

I have a field in a query that calculates the average miles between two
points. I changed the properties to set it to show zero decimal places yet it
is still returning values with multiple decimal places. How do I fix this?

 

[John W. Vinson]

I have a field in a query that calculates the average miles between two
points. I changed the properties to set it to show zero decimal places yet it
is still returning values with multiple decimal places. How do I fix this?

Use the Round() function to round your result to zero decimal places in the
calculated expression. If you'ld like help doing so post the expression you're
using - we can't see it from here.