S
Spencer
I have data that tells me the following: sales rep, recruiter of sales rep,
manager of sales rep and sr. manager of sales rep. I need to run a report
that will list all the sr. managers, then have all the managers under that
sr. manager, then all the recruiters under each manager and finally all the
sales reps under each recruiter.
Sales rep Recruiter Manager Sr. Manager
Mike Joe Mary Carol
Anita Sally Mary Carol
Cathy Nicole Keith Steve
It would need to look like this:
Carol
Mary
Joe
Mike
Sally
Anita
Steve
Keith
Nicole
Cathy
I have a table with the sales rep detail (SalesRep_tbl), recruiters
(Recruiter_tbl), managers (Manager_tbl) and sr. managers (SrManager_tbl).
Everyone is listed in the sales rep table, and the foreign key of the the
other tables is the sales rep ID, primary key of the SalesRep_tbl. The last
table I have is SalesRepDetail_tbl which has the data as to what manager,
recrutier and sr manager is associated with each sales rep.
I'm not great with Access but not a beginner. How do I create the queries
that will let me generate the report?
Thank you in advance. Hope this made sense.
manager of sales rep and sr. manager of sales rep. I need to run a report
that will list all the sr. managers, then have all the managers under that
sr. manager, then all the recruiters under each manager and finally all the
sales reps under each recruiter.
Sales rep Recruiter Manager Sr. Manager
Mike Joe Mary Carol
Anita Sally Mary Carol
Cathy Nicole Keith Steve
It would need to look like this:
Carol
Mary
Joe
Mike
Sally
Anita
Steve
Keith
Nicole
Cathy
I have a table with the sales rep detail (SalesRep_tbl), recruiters
(Recruiter_tbl), managers (Manager_tbl) and sr. managers (SrManager_tbl).
Everyone is listed in the sales rep table, and the foreign key of the the
other tables is the sales rep ID, primary key of the SalesRep_tbl. The last
table I have is SalesRepDetail_tbl which has the data as to what manager,
recrutier and sr manager is associated with each sales rep.
I'm not great with Access but not a beginner. How do I create the queries
that will let me generate the report?
Thank you in advance. Hope this made sense.