Hi
I'm completely stumped (as usual)
I'm trying to calculate the accuracy rate by analyst by month.
I can easily calculate it one month at a time.
What I need is to create a graph on a report that shows accuracy rate by month and I think my queries are bad.
I think I need one query that will display my results by month but I'm unsure how to write that.
I have a series of select queries that give me results then I calculate the accuracy rate but I have to tell them what the month it is in the select queries. So I would need to run this batch of queries for every month. (which is stupid)
If I take out the month criteria then it lumps everything together. How do i make it calculate by each month separately?
I think it must be something simple that I'm missing (usually is).
Any thoughts on how to give results by month all in 1 query?
Thanks so much.
I'm completely stumped (as usual)
I'm trying to calculate the accuracy rate by analyst by month.
I can easily calculate it one month at a time.
What I need is to create a graph on a report that shows accuracy rate by month and I think my queries are bad.
I think I need one query that will display my results by month but I'm unsure how to write that.
I have a series of select queries that give me results then I calculate the accuracy rate but I have to tell them what the month it is in the select queries. So I would need to run this batch of queries for every month. (which is stupid)
If I take out the month criteria then it lumps everything together. How do i make it calculate by each month separately?
I think it must be something simple that I'm missing (usually is).
Any thoughts on how to give results by month all in 1 query?
Thanks so much.
