Determine Ratio in ACCESS query
Posted on 2010-09-02
Ok, this is going to be an obscure solution. I saw this once done many many years ago and am trying to figure out how to do it in ACCESS 2003 today as I remember. I have a query that has activities called a "job". In a "job", there are various numbers of reports. Now these reports are run each day, but some may fail. I need to determine the ratio of failures to the total numberof reports in each job. So, I can have five jobs, each job holds 10 reports. Say job ONE runs but 2 out of 10 fail, so taht ratio is 2/10. Fine, but in my queries I have the five jobs and i need to determine the ratio of failures for each job. I am trying to avoid doing a lot of summing in queries and the combineing, etc. It was a neat trick to do in one query and was wondering if anyone had ever seen/solved this same problem.