I would like to create a report showing, for each technician, how many Open Requests, Problems & Tasks they have.  I have reports for all Open Requests, all Open Problems & all Open Tasks but they are separate reports.  What I want is to join this information together so it shows, by Technician, the total number of Open activities for each technician.

ie:

Tech A            requests = 23, problems = 5, tasks = 10, total = 38

Tech B            requests = 9, problems = 2, tasks = 15, total = 26

etc.

I assume this requires a query report but my knowledge of constructing queries is only very basic.

Has anyone already done anything similar ?