my employee listing

[Guest]

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

 

[Amy Blankenship]

What are your fields?

 

[Guest]

just gender and birthday

What are your fields?

 

[Amy Blankenship]

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

 

[Guest]

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

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

 

[Amy Blankenship]

First, I'd do something like this:

Select DateDiff("yyyy", Date(), Birthday) AS Age, Gender FROM CensusData

Save that query as qryAgeGender

To get your aggregation from that data, you can apply the concepts from this
video.
http://www.datapigtechnologies.com/flashfiles/crosstab.html

If you need more specifics on how to apply the concepts, post back.

HTH;

Amy

 

[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