I have two queries. Both the queries comes from the same table.
Therefore, both queries have similar columns.
qry3
Fiscal Year
Quarter
Call
Visit
TotalOfMetricsID
qry4
Fiscal Year
Quarter
Yes
TotalOfMetricsID
the quarter consists of Q1, Q2, Q3, and Q4 of the fiscal year
Now I want to create a query where I can get the %/average of qry3 and qry4 with respect to the quarters and Fiscal year..
like
2008 Q1 = AVERAGE
2008 Q2 =AVERAGE
2009 Q1 =AVERAGE
The average/% should have formula like
(qry4totalofmetricsID/qry3totalofmetricsID)*100
Now how should I go about doing this? any ideas anyone?