Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count the students per month in a report (Access 2000)

    I want to count the number of the students in my report.How can i do it ?
    My report is formated for the months view,on the field LastUpdated, the LastUpdated Header.
    =Format$([LastUpdated];"mmmm yyyy";0;0)

    In the details section i have the list of the students.How can i count the number of the students
    for each month ?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count the students per month in a report (Access 2000)

    In the detail section add a textbox with control source =1 (with equal sign). Set the visible property to false and the Running Sum to Over Group. Name it Counter.
    In the Group Footer of LastUpdated add a text box with control source = Counter. This will give you the count of the students for each month.
    Francois

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count the students per month in a report (Access 2000)

    As an alternative to Francois' solution, you can put a text box in the group footer for LastUpdated with control source =Count(*)

Posting Permissions

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