L
LW Access Newbie
I have a table with employee data. I am trying to get summary data for each
job title.........for EACH title, I am trying to get the following counts:
number of all employees with the title, number of females with the title,
number of minorities with the title. Also, I want to group the data by
Business Unit (Division). I am able to get each count in a separate query,
but I am not able to get in one query a single record for each title that has
all the counts. For instance:
Job Title: Accountant Total EE's: 25 Females: 19 Minority:
10
Job Title: Developer Total EE's: 75 Females: 38 Minority:
26
Job Title: Tester Total EE's: 30 Females: 12
Minority: 11
Job Title: Manager Total EE's: 8 Females: 4
Minority: 2
Thanks!!!!!
job title.........for EACH title, I am trying to get the following counts:
number of all employees with the title, number of females with the title,
number of minorities with the title. Also, I want to group the data by
Business Unit (Division). I am able to get each count in a separate query,
but I am not able to get in one query a single record for each title that has
all the counts. For instance:
Job Title: Accountant Total EE's: 25 Females: 19 Minority:
10
Job Title: Developer Total EE's: 75 Females: 38 Minority:
26
Job Title: Tester Total EE's: 30 Females: 12
Minority: 11
Job Title: Manager Total EE's: 8 Females: 4
Minority: 2
Thanks!!!!!