<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2726.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><STRONG>Michael,</STRONG></DIV>
<DIV> </DIV>
<DIV> Could you kindly send a copy of sample db to me as
well?</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=michael.mattys@adelphia.net
href="mailto:michael.mattys@adelphia.net">Michael R Mattys</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 15, 2003 17:11</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] A2k - Age
ranges</DIV>
<DIV><BR></DIV>Carlos,<BR><BR>You may be looking for the Partition
function<BR>I have a sample db, if you need it I'll send it.<BR><BR>Michael R.
Mattys<BR><A
href="http://www.mattysconsulting.com">www.mattysconsulting.com</A><BR><BR><BR>-----
Original Message -----<BR>From: "Carlos Alberto Alves" <<A
href="mailto:caa@highway.com.br">caa@highway.com.br</A>><BR>To: "Access
Developers discussion and problem solving"<BR><<A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>><BR>Sent:
Friday, August 15, 2003 4:38 AM<BR>Subject: [AccessD] A2k - Age
ranges<BR><BR><BR>> Dear Mates:<BR>> I am trying to solve an apparently
simple situation but cannot find a good<BR>> solution. My app has a table
Patients with a birthdate, among other data.<BR>> Users asked me to set a
query and a graph with number of patients per<BR>> range, for example
<20y, 21 to 30y, 31 to 40y,...,>80y. For some "strange"<BR>> reason I
have got a solution for only one range per query.<BR>> Anybody has a better
solution, like a crosstab query that supports all<BR>>
ranges????????????<BR>> I have my own Age function!!! ;-)<BR>>
TIA,<BR>> --<BR>> **************************************<BR>> *
Carlos Alberto
Alves
*<BR>> * Child
Neurologist
*<BR>> * Systems
Analyst/Programmer *<BR>> *
Rio de Janeiro,
Brazil
*<BR>> * <A
href="mailto:caa@highway.com.br">mailto:caa@highway.com.br</A>
*<BR>> **************************************<BR></BLOCKQUOTE></BODY></HTML>