In my database there is a report for daily productivity. It takes the individual numbers from the associates and list there performance and other scores. At the bottom of the report in the footer it is supposed to average all the individual scores and report the shift daily average. The problem I have is it is not seemingly calculating average correctly.
When I take all the individual performance numbers and average them in excel I get 97%. Access is taking the same numbers and returning 87%. Since the base data is the same it has to be something in the way access is seeing the data or in the way Access handles the data calculation but I can not figure out what it is.
The report is the daily productivity report. the shift is 1st and the start date and the end date are both 1/29/2019. Let me know what you guys think.