Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18

Thread: range wise Count

  1. #16
    Join Date
    Dec 2008
    Posts
    37

    Employees

    Hi Allan

    Thanks for the your new sample DB.

    After much Googling, I had finally figured out how to create a new module and rename it in VBA! Today I plan to create new queries and your new example DB confirms that I was on the right track.

    Thanks so much for all your help.

    Tony Randell

  2. #17
    Join Date
    Dec 2008
    Posts
    37
    Hi Allan

    Just to let you know that everything is now working correctly.

    Thanks for your help

    Regards

    Tony Randell

  3. #18
    Join Date
    Jun 2009
    Posts
    1
    Quote Originally Posted by makpk View Post
    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
    I would add two fields to your table

    Field = Category
    Field = Category Description.

    Write queries to categorize each record with a category number assigned to each of the birth date ranges. Cat1 to Cat7

    Then write a final select query to group on category sorted ascending and count each category while also displaying the category description.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •