[AccessD] A2k - Age ranges

On Fri, 15 Aug 2003 07:41:31 -0400, Michael R Mattys 
<michael.mattys at adelphia.net> wrote:

> Carlos,
>
> You may be looking for the Partition function
> I have a sample db, if you need it I'll send it.
>
> Michael R. Mattys
> www.mattysconsulting.com
>
>
> ----- Original Message -----
> From: "Carlos Alberto Alves" <caa at highway.com.br>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Friday, August 15, 2003 4:38 AM
> Subject: [AccessD] A2k - Age ranges
>
>
>> Dear Mates:
>> I am trying to solve an apparently simple situation but cannot find a 
>> good
>> solution. My app has a table Patients with a birthdate, among other 
>> data.
>> Users asked me to set a query and a graph with number of patients per
>> range, for example <20y, 21 to 30y, 31 to 40y,...,>80y. For some 
>> "strange"
>> reason I have got a solution for only one range per query.
>> Anybody has a better solution, like a crosstab query that supports all
>> ranges????????????
>> I have my own Age function!!! ;-)

That's exactly what I need!!!
Thanks very much, Michael!!!  :)
-- 
**************************************
* Carlos Alberto Alves               *
* Child Neurologist                  *
* Systems Analyst/Programmer         *
* Rio de Janeiro, Brazil             *
* mailto:caa at highway.com.br          *
**************************************