I am trying to write a report that graphs percentages over time. There are 6 required elements for each case, and I would like to graph the percentage of each element completed over all the admissions each day. I am able to do this one of two ways.
1. (Preferable, but I am not sure if it is possible) I have written a report that has all of the percentages calculated and I would like to write my graph based on the results in particular controls in the report ad they are displayed in the group.
2. I have written a query that displays the dates, a count of the number of cases completed for each day, and a count of the number of required elements for each day. I cannot figure out how to divide
CountOfElements/CountOfAdmissions
I get an error when I use my CountAdmissions column as the denominator in the expression. Please help if you are able. I am familiar with using Chart in Excel, but have never used it in Access. I have figured out how to graph my Counts from my query in #2 above, but it is a graph of the PERCENTAGES I am looking for. Thanks!
1. (Preferable, but I am not sure if it is possible) I have written a report that has all of the percentages calculated and I would like to write my graph based on the results in particular controls in the report ad they are displayed in the group.
2. I have written a query that displays the dates, a count of the number of cases completed for each day, and a count of the number of required elements for each day. I cannot figure out how to divide
CountOfElements/CountOfAdmissions
I get an error when I use my CountAdmissions column as the denominator in the expression. Please help if you are able. I am familiar with using Chart in Excel, but have never used it in Access. I have figured out how to graph my Counts from my query in #2 above, but it is a graph of the PERCENTAGES I am looking for. Thanks!
