Multi-month data strategy

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?
 
D

Duane Hookom

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
 
J

Jeff Boyce

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top