Multiple Sets of the Same Data on 1 Report

[rmikulas]

Hi All!!



New to AccessForums.net! I am a novice at Access. I have been using Excel forever, and I am pretty good at it, but finally have been running into projects that I cannot possibly do in Excel anymore I should have gone to Access a while ago. I am currently working on my second (very basic) database and running into a problem, so I am reaching out to everyone for any help you can provide.

Problem: I have a database of Employee Weekly Statistics based on 3 different criteria. I have a separate table for each of the 3 Categories. I would like to build a report that displays the last 4 weeks of each individual employee's 3 Categories.

I built a query that will display as follows, but I can't seem to figure out how to create a Printable Report for each employee that I can give them with the separate data.

Week Emp_Name Category1 Category2 Category3
1 Joe 80% 5 100
2 Joe 88% 6 102
3 Joe 89% 5 101
4 Joe 91% 5 100
1 Sam 75% 2 99

etc

Once the Data is displayed, can you put a Graph on the report, that can show you for Joe in Category1 he is Trending upwards? Maybe the graph is too much, I really just want to be able to start with displaying the data for each Employee, sort of like a Scorecard for them.

Any help will be greatly appreciated, or even pointing me in the direction of a helpful article on the web.

Thanks all!!

[rmikulas]

I had included a picture, but then thought that it may have just complicated the issue, when I'm looking for a simpler version than the picture I had up.