I have a report based on a query and it calculates the average monthly supplier rating based on certain criteria such as quality, on time delivery etc. The problem that I am having is that I want to be able to take a monthly average rating of the individual suppliers ratings. I can get it to display a result, but the calculation is not correct. I have attached a picture that shows the code for the individual average ratings, the ones I want to add together and take an average for. The query has parameters for month and year to narrow in on the data I want. Also, I can't remember how to make a query/report only show the last X months of data. I had an example of it with something like the (date, -12) for the previous 12 months. Thanks for any help.
Tim
Tim
