Help With Query

  • Thread starter Thread starter DavidPuddyFan
  • Start date Start date
D

DavidPuddyFan

I'm going another way, but still need help on the final part...here i
where I am. I have a report that basically takes employee census dat
and summarizes it down to Count of Gender by Division. This is
overall report. What I am trying to do is break it down by month....s
it will give me the following detail:

DivisionName Month1 Month2
#ofMales #ofMales
#ofFemales #ofFemales

On the report, I'm using the following to get me my count o
gendercodes, so there's got to be a way for me to use a Where statemen
=Sum(Abs([GenderCode]="M"))
I figure I can get the dates needed from HireDate and Termination date
but just don't see how I can break it down to this format

Thanks for your help
 
Hi,


Make a crosstab query, group on division AND on sex; pivot on Month(
MyDateAndTime ); aggregate with a COUNT on any field without null.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top