Access - Rounding an average in a report

HI Guys

Hope you can help

I have a simple database in Access with a query and report set up that generates average weights per delivery per destination.

I have set up the query with an average of the totals for the destination in question, however, when I run the report I cannot get the result to two decimal places.

Ive tried using Round(Avg(weight),2) in the Total field in the query as suggested from another source but unfortunately, I keep getting an error.

Could anyone advise on how this can be achieved?

I have attached the database - any suggestions would be very welcome

J
DPD---Copy.accdb
Jase AlexanderCompliance ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You could set Decimal Places = 2 and Format = Percent for that Textbox on your report.

I keep getting an error.
When I run the report I don't receive any error. Can you clarify that comment?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jase AlexanderCompliance ManagerAuthor Commented:
HI Scott

Thank you for the response

Sorry, the error alert is when I try to enter the ROUND criteria into the query section not on the actual report itself - im not sure if Im doing this correctly but its says 'field doesn't exist' or something of that nature.

Ive attached where Im trying to enter this - not sure if I am doing this correctly ?

Can you show me via a screen grab where I would set the decimal place and format as you suggested?

Many Thanks

J
Query_Error.docx
0
Jase AlexanderCompliance ManagerAuthor Commented:
Many thanks for your help Scott

Sorted with your direction

J
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.