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

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?

sure bob will do

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