Employee Injuries Database - Creating graphs?

[B984rnr]

Does anybody have a sample database that worked with employee injuries?

I am trying to automate some of our copy/paste excel month end reports for injury rates, quantity of recordables, and similar. As it stands now I have my tables set up and my new injury input mostly setup. I am currently running a query that filters out the first aid and near hit cases and returns only the recordable injuries. I need to get a count of these injuries and graph them over time(X=months, Y=number of injuries in X month).

What is the best way to do this?

Let me know if you need more information.

 

[GinaWhipp]

If you have a query that gives you this information you could use the Report Wizard to create your graph.

 

[B984rnr]

If you have a query that gives you this information you could use the Report Wizard to create your graph.

As it stands right now my query outputs a list of injuries, but not a tallie our total. My problem is getting access to count the (non-numeric) entries and create a line graph with the points on the graph being number of injuries per month. For example, 1 injury in january, but 2 more in february for a total of 3, then none in march so the total stays at 3. Each months numbers add to the previous months totals to create a new data point on the line graph.

My current query only outputs:
Injury date (i.e. 1/09/2011)
Injury type (abrasion, laceration, etc.)
body part
A brief description of injury

It currently outputs 10 injuries over 2011 ytd, fairly evenly spread across the nine months of the year.

 

[jdraw]

There is a general data model for Accidents at Work at
http://www.databaseanswers.org/data_models/accidents_at_work/index.htm

You can see the "business facts" associated with the model from a link on the quoted page.
It may give you some ideas.
Good luck.

 

[GinaWhipp]

Aside from JDraw's suggestion... You should look into *Groups and Totals* queries. You will have to *massage* the query but it might get you close to what you want.

 

[B984rnr]

I know you already gave an answer, but I was thinking these might help. The jpeg is what I'm trying to create from, obviously, the attached database.

View attachment Database1 9-21-11 (no info).accdb