Re: my employee listing

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%233MepZRqGHA.4492@xxxxxxxxxxxxxxxxxxxxxxx
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

"rodchar" <rodchar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8E90DB64-6A86-4B84-A7D0-406D1982F9B9@xxxxxxxxxxxxxxxx
census info. for the State Dept. of H.R.


"Amy Blankenship" wrote:

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

"rodchar" <rodchar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:67E50334-F864-44D9-A5FD-92CE4C3D54F0@xxxxxxxxxxxxxxxx
just gender and birthday

"Amy Blankenship" wrote:

What are your fields?

"rodchar" <rodchar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D4261834-7E59-4C49-884C-C3D9F91D8297@xxxxxxxxxxxxxxxx
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










.

Relevant Pages

  • Re: kindergarten concerns
    ... I had an early November birthday in 1937, and at that time it was ... I graduated in 1955 at age 17. ... napping type child. ... That's what kindergarten used to be about, rather than academics, ...
    (misc.kids)
  • Re: Triplets
    ... It depends on the probability distribution of the time interval ... between the two births, and I have no idea what that is. ... your age changes when your birthday starts, ... is to treat a February 29 birthday as falling on February 28 in non-leap ...
    (alt.usage.english)
  • OT: And another day older...
    ... Today is my 39th birthday. ... I'm nine years away from being the same age as my father when he ... opportunities to play the field a little bit, in a great band, living ... and a fantastic singer. ...
    (alt.guitar.bass)
  • Re: Calculate someones age in Access and format the result in yea
    ... To get their current age, ... birthday this year, and adjusts the results of DateDiff accordingly. ... >>>I want to calculate someones age calculating the difference between ... I want to use an expression in a calculated field in a form, ...
    (microsoft.public.access.forms)
  • Re: OT/ Comfortably Numb
    ... both of my sisters were dead by the age i am right now. ... complications of diabetes. ... next month is my birthday. ...
    (alt.support.diabetes)