Hello!

I have some data of people with "date of birth" I calculated the age of each person in a query. Now I want to Count the record in different ranges! i.e.

Less than 1 Year: .................
Between 1 to 5 Year: ................
Between 6 to 20 Year:...............
Between 21 to 40 Year:.............
Between 41 to 60 Year:.............
Between 61 to 80 Year:.............
Above 80:.....................

I counted the record for 1st range and it works but when I tried for 2nd both creteria doesn't work!

anyone can help...............

THANK YOU in ADVANCE