[AccessD] A2k - Age ranges

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!!! ;-)
> TIA,
> --
> **************************************
> * Carlos Alberto Alves               *
> * Child Neurologist                  *
> * Systems Analyst/Programmer         *
> * Rio de Janeiro, Brazil             *
> * mailto:caa at highway.com.br          *
> **************************************
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com