Age Groups

[Dazzla]

I have a patient form that has the patients age on it. i now want to count the number patients in different age groups by gender. Say 25-35, 26-45 etc. and put this into a report.

Is this possible to do in a query or report

 

[Brianwarnock]

Yes your query will group by gender and have a series of calculated filds such as age20-29: Sum(IIf([fldage]>19 And [fldage]<30,1,0)) with expression in the total line of the grid

Brian

 

[Pat Hartman]

Look up the Partition() function. As long as your groups are equal size, it will do the work for you. No need for a nasty IIf().

BTW, Hope you're actually storing birth date rather than age. Age becomes dated (pun intended) over time.

 

[Brianwarnock]

Look up the Partition() function. As long as your groups are equal size, it will do the work for you. No need for a nasty IIf().
QUOTE]

Since when did management make life that easy, they always want those over a certain age lumped together
What's nasty about the IIf() a lovely flexible little function

The presentation of the output from the 2 approaches is also quite different, as I want to group by gender usually within another grouping I find the IIf output easier to handle.

Brian

 

[Dazzla]

Thanks for the help, all is working fine now.