Age Range in Report

[maintt]

Hi Guys
I have used code to construct an age range Ie:
16-24 25-34 35-44 45-54 etc.. this works fine on the report showing 4 client ID No's (4 records currently in the report in test) each in a different age range, what i want to do is know how many client Id's there are in each Age range as a summary report by total each range ie
1 in 16-24
1 in 25-34
1 in 35-44
1 in 45-54

I will have 2500 clients in the database at the finish and rising daily

any help appreciated

Thanks Maintt

 

[boblarson]

No need for code to get the ranges. It should be able to be done all in a single query. Do you have a sample table that you can upload?

 

[maintt]

sure bob will do

 

[maintt]

hi bob cant upload until at work, really appreciate yours and others help, i am in recovery for mental breakdown and unemployed but have volunteered to work in a recovery unit helping people to use computers, and agreed to set up various databases to help them track clients like me, my aim is to get a job which i need, so i really do appreciate all the help you and your collogues can give, so bare ith me please and i will respond asap

be good

maintt