[AccessD] A2k - Age ranges

Michael,

    Could you kindly send a copy of sample db to me as well?

Regards,
A.D.Tejpal
--------------
  ----- Original Message ----- 
  From: Michael R Mattys 
  To: Access Developers discussion and problem solving 
  Sent: Friday, August 15, 2003 17:11
  Subject: Re: [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          *
  > **************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030815/c3715868/attachment-0001.html>