I have a graph that is pulling data from a query. The name of the query colums are Total and dateofaudit that I am using for this problem. I enter the number of findings I find in the total column and enter the date of the audit. I want to show how many findings I have for the entire year, either being 2010, 2011 etc.
Here is what I am trying to do:
Total for dateofaudit that equals the year 2011 etc.
Total for 2011 would be 9.
I'm not sure if I should do this in the query or report. Thanks!