my employee listing

R

rodchar

hey all,

i have a table of employees and what i'd like to do is group by male and
female. but also would like a count of which employees fall in a specific age
range.

I know how to do the first grouping but how would i do the 2nd one?

thanks,
rodchar
 
A

Amy Blankenship

What good does it do you to know the genders and birthdays if you don't know
who the people are?
 
R

rodchar

census info. for the State Dept. of H.R.


Amy Blankenship said:
What good does it do you to know the genders and birthdays if you don't know
who the people are?
Click to expand...
 
D

Douglas J. Steele

Of course, that won't be a completely correct age: it will say people are
older than they are if they haven't already had their birthday.

Select DateDiff("yyyy", Date(), Birthday) - IIf(Format(Date(), "mmdd") <
Format(Birthday, "mmdd"), 1, 0) AS Age, Gender FROM CensusData
 
Top