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