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