From a table that stores such things about a job applicant as gender, race,
disability, veteran status, etc. and which table also holds an "Action
taken" column (which can be:



Hired

Not Interviewed

Interviewed-job declined

Did not meet qualifications

Etc.



I need to be able to see which actions were taken by gender, by race, etc.



The only "start" that I can come up with is something like:



Select gender, Count(ActionTaken)

From Applicants

Where Action = Hired

Group by Gender



But I need the results for every action taken, not just "Hired" - I need
results like:



Gender Hired Not Interviewed Did Not
Meet Quals

Male 2 3
2

Female 3 2
1



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]