Hi there,
I have a database that keeps track of adverse incidents in a hospital. I'd like to provide some feedback to individual managers in a general form, and then see how they'd like the data presented in the future.
Im thinking I could provide summaries of total incidents from the last 5 fiscal quarters. I am thinking that 2 queries would be great:
1. Shows the total number of incidents as well as the number of serious and moderate ones.
2. Shows the total number of incidents broken down into the different types of incidents.
Is there a way I can build a query or a chart in access that will show me the info from "1" and "2" in two charts?
Thanks
-Z
I have a database that keeps track of adverse incidents in a hospital. I'd like to provide some feedback to individual managers in a general form, and then see how they'd like the data presented in the future.
Im thinking I could provide summaries of total incidents from the last 5 fiscal quarters. I am thinking that 2 queries would be great:
1. Shows the total number of incidents as well as the number of serious and moderate ones.
2. Shows the total number of incidents broken down into the different types of incidents.
Is there a way I can build a query or a chart in access that will show me the info from "1" and "2" in two charts?
Thanks
-Z
