Access - Rounding an average in a report

Jase Alexander
Jase Alexander used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
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?
Jase AlexanderCompliance Manager

Author

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
Jase AlexanderCompliance Manager

Author

Commented:
Many thanks for your help Scott

Sorted with your direction

J

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial