Results 1 to 7 of 7
  1. #1
    Join Date
    May 2006
    Posts
    386

    Unanswered: Is it possible to count the total number of rows in a report under the Report Footer

    Dear All,
    I have a report and at the moment, I have added one lable under the Detail section of the report to count number of rows for each group. I have created a lable and in the Control Source section I have written
    =1
    and it is working fine and gives me the numebrs in sequence i.e. 1, 2,3 etc.
    However, I now want to calculate the total number for each group based on the above numbers i.e. If one employee has done two job and another employee has done 5 job, then the total of each group (employee) numbers should be calculated.

    I have tried the same procedure
    =1
    and changed the RunninSum to Overall but it still does not work. By the way, it does not have to be based on that particular field as long as it gives me the total number of rows for all groups.

    Any help would be much appreciated.

    Emi
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    Hi Emi,
    In which edition you work? if it is 2007 you can manage your problem with 'Group & Sort' in Grouping & Totals Menu, I dont remember if 2003 edition has this option and don't have 2003 on my computer at the moment.
    you can use count function as well without using group & sort
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  3. #3
    Join Date
    May 2006
    Posts
    386
    HI Aran,
    Thank you for your response. I use Ms Access 2002.
    At the moment I do not have a field within table or queries to run the count or sum calculation on it. I created a lable and called it txtNo and then added =1 and pasted it in the Report Footer section and changed the RunningSum to Overall. This works under the Details section and it works under this and gives me total number of rows (records) however, it does not give me the total of all groups from the Detail section. I would appreciate if you give me a step by step procedure as i have tried everything i know but still no luck.

    thanks once again.
    Emi-UK
    Love begets Love, Help Begets Help

  4. #4
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    use of =1 in textbox gives ranking to your report and as well total of your records at the end but as far as I undrestand you need access to count records of each group, so you should add a group footer to your report design by using sorting & grouping option located in Report Design menu (you have this menu when you open the report in design mode) then add the group footer based on that field you want to have record count and after creating the group footer in your repot put a textbox and add this function to it =count([the field name to be counted])
    I know my explanation is not very clear but give it a try and let me know if you have any question
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  5. #5
    Join Date
    May 2006
    Posts
    386
    that is fantastic. It works perfect. Thank you for your help.
    Emi-UK
    Love begets Love, Help Begets Help

  6. #6
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    I'm happy it was usefull, Cheers
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    =Count(*) usually does the trick
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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