Creating a report to show errors by associate

[Nymandus]

The subject line is simple the detail is not

I am working on improving my database (the first one I created a year ago while teaching myself access)

I fully expect the problem may be in my design, but I am hoping to overcome it.

The database is to track and evaluate call center associate phone calls. I
I created yes/no fields for multiple common errors (accurate/complete, Security, and client experience. and under each are @ 20 common errors)
(the problem is that I did not create a seperate table for each main category which I think might have made things easier):banghead:


now what I am trying to do is create a report that allows me to show (or select) an error and have it show all the associates that had that error in a given time frame.


I already have a report to show all associates and all the errors that each had in a certain time frame. (so vertically I have associate detail and horizontal I have error detail)

is there a way, without creating 25 seperate reports, to show all associates under an error type?

 

[burrina]

Yes, it's called Grouping.

 

[Nymandus]

Grouping would be great....however I have over 20 categories and as far as I can tell you can only group a limited number(4 is a reports limit), so how would you suggest grouping 20+ or is it different if I do not use the wizard?

 

[burrina]

Seems like a case for subreports.