query and count then to report

[scratch]

I needed to get a report that is based on year. The default report doesn't group them by year. Right now I have a query that extracts the year from each date. I'm guessing the next step is to count the number of occurences for each year. Then finally take each distinct year and base the graph on the count for each year. While I have an idea on how this may work, I don't know how to implement it.

scratch

 

[KeithIT]

If you are using a report just View - Sorting and Grouping and then group on the year value. Your query shouldn't have any of the sorting or grouping information in it, you shoud do that from within the report to make the query more universal.

 

[scratch]

that did the trick, thanks