Link to home
Start Free TrialLog in
Avatar of Jase Alexander
Jase AlexanderFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jase Alexander

ASKER

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
Many thanks for your help Scott

Sorted with your direction

J