G
Guest
If I have a table for the month of June that has:
Citation #, Officer, Date, Time, Race, Sex, Search
I want to run a query that will group the officers and give me a total of
citations written by the officer, then give me a total for race and sex
(example for smith)
June 2006
Officer race sex Total Citations Written Total Race Total Sex
Smith m w 22 5
5
Smith m b 10
10
Smith f w 5
5
Smith f b 2
2
Citation #, Officer, Date, Time, Race, Sex, Search
I want to run a query that will group the officers and give me a total of
citations written by the officer, then give me a total for race and sex
(example for smith)
June 2006
Officer race sex Total Citations Written Total Race Total Sex
Smith m w 22 5
5
Smith m b 10
10
Smith f w 5
5
Smith f b 2
2