Total percentage for a query

G

Gregw

I have the following query:

SELECT qry1.OrderYear AS OrderYear, qry1.OrderMonth AS OrderMonth,
qry1.CountofFileNumber AS FilesOpened, qry2.FilesClosed AS FilesClosed,
qry2.SumofGross AS SumofGross, (qry2.FilesClosed/qry1.CountofFileNumber) AS
[% Closed]
FROM qry1 LEFT JOIN qry2 ON (qry1.OrderMonth = qry2.CloseMonth) AND
(qry1.OrderYear = qry2.CloseYear)
ORDER BY qry1.OrderYear, qry1.OrderMonth;

which gives me the total number of orders for each month, total number of
orders closed in each month, and a percentage of files ordered vs. closed.
Is there a easy way to sum up all the "% Closed" and get an average by year
or an overall average?

Thanks for the help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top