Summary Data

[Zorkmid]

Hi there,

I have a large database that catalogues incidents, keeping track of data such as:

-where the incident happened
-who it happened to (visitor, employee, volunteer etc.)
-what type of incident it was (2 fields, general and specific: ex: fall -> tripped)
-when it happened

So now I've finished building the forms to enter/edit records, and I need to build queries and reports that summarize the data so I can push it out to managers of specific departments.

Am I correct in building crosstab queries to start?

What are you thoughts on the best way to begin this process?


-Thanks,
Z

 

[HiTechCoach]

Hi there,

I have a large database that catalogues incidents, keeping track of data such as:

-where the incident happened
-who it happened to (visitor, employee, volunteer etc.)
-what type of incident it was (2 fields, general and specific: ex: fall -> tripped)
-when it happened

So now I've finished building the forms to enter/edit records, and I need to build queries and reports that summarize the data so I can push it out to managers of specific departments.

Am I correct in building crosstab queries to start?

What are you thoughts on the best way to begin this process?


-Thanks,
Z

Hard to say where to start without having some clue on the tyye of summary reports are needed.

You might start with totaling queries.

TIP: You can use sub reports to print stats from different queries on a single report.

 

[Zorkmid]

The types of summaries I need to do are things like

1. Totals of each type of incident for each location for each month.
2. Percentage of severe incidents against the whole
3. Percentage change from one mkonth to the next

things like that

They are mostly ad hoc but I'd like to build ones that I can run and push out every month to the managers of each location.

-Z