We help IT Professionals succeed at work.

Access - Rounding an average in a report

Jase Alexander
on
96 Views
Last Modified: 2017-03-22
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

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
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