[AccessD] A2k - Age ranges

Carlos Alberto Alves caa at highway.com.br
Fri Aug 15 03:38:08 CDT 2003


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          *
**************************************


More information about the AccessD mailing list