I have created a query with calculated fields that I have set to only display whole numbers. Is there a way of also asking the calculation to round the result to multiples of 5?
I am sorry I forgot to check with you GoDawgs where you would enter this piece of code? I am afraid I am still finding my way around Access and realise this may be a stupid question, but I appreciate your help with this.
You can make it another field in your query. Just paste that directly in to a blank column in the query and then run the query and that column should have everything rounded to the nearest 5.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.