Multi-month data strategy

  • Thread starter Thread starter Wendelin
  • Start date Start date
W

Wendelin

I'm trying to figure out the best way to approach a report that shows
multiple months of data for each employee (20). I'm pulling different types
counts per month from one table which need to be displayed for each month.
The data is at the date level, not month.

Report example (only prettier):

Name: John Doe
Months: Jan/Feb/Mar
Grievances: 10/15/12
Errors: 2/4/1
Correct type: 0/1/1
Correct categ: 0/1/0
Doc source: 2/2/0

Should a query be built for each month? With a prompt for employee?
 
We don't have a clue how your data is stored. How about providing some table
and field names and sample records?

I would think you could use totals queries, crosstabs, subreports, etc
 
Have you looked into "crosstab queries"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top