creating a form

I have a column for patients age on a form that i am creating but during
analysis/ reporting I want to report total number of patints ages in age
ranges like below

10-14;15-19;20-24;25 - 29;30- 34;35 - 39 and so on
no of patients 3 5 54 76 43 21
that is 3 patients had ages between 10 and 14 ..and so on

how can i do this

yemi

reportyemi wrote:
I have a column for patients age on a form that i am creating but during
analysis/ reporting I want to report total number of patints ages in age
ranges like below

10-14;15-19;20-24;25 - 29;30- 34;35 - 39 and so on
no of patients 3 5 54 76 43 21
that is 3 patients had ages between 10 and 14 ..and so on

how can i do this

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can use the Partition() function in the report's query, like this:

SELECT Partition(patient_age,10,89,5) As AgeRange, COUNT(*) As Patients,
... other columns, if any ...
FROM table_name
WHERE criteria.... etc. ...
GROUP BY Partition(patient_age,10,89,5)

The Partition() function returns a string like the following:

:10
10:14
15:19
20:24
25:29
.... etc. ...
90:

In the above example, I've set up the Partition() function to only work
on ages between 10 and 89. Every age below 10 will be represented as :9
(i.e., 9, or younger). Every age above 89 will be represented 90:
(i.e., 90, or older).

If you want more "human readable" partitions you could use this formula
(watch out for line wrap):

Replace(Replace(Replace(Partition(Age,10,89,5),":" ," - ")," -
9","below 10"),"90 - ","90 and above")

, which means you'll have to put the same formula in the GROUP BY
clause.

HTH,
--
MGFoster:::mgf00 at earthlink decimal-point net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSlVxxIechKqOuFEgEQK/xgCggwxT8NrKr+Fc1GvkDFWXiJOGnuYAniH7
WYjWGKQUj01A+FhZ+AEimycK
=3Kyk
-----END PGP SIGNATURE-----