Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Jacksonville,NC, USA
    Thanked 0 Times in 0 Posts
    I have tried grouping in the query (as shown in the word example of graphics that I am attaching) for this report, but no matter what I do, I can’t seem to get all names listed once in the report. It shows every occurrence of a lab visit.

    It doesn’t matter how many times they came, I am only trying to get their TOTAL Time which is working fine…but their names listed only once beside the total time that they visited. HELP
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts
    You have a GroupBy on the Time field (you might want to rename that - Time is probably a reserved word in some contexts). Remove that field, or if you are trying to constrain your results to a given period put a criteria on it and set the GroupBy to Where.

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Cambridge, UK
    Thanked 3 Times in 3 Posts
    Can you not HIDE the Detail Band in the Report (Visible Property to false) and just put the Students Name fields into the [TIME] Footer.
    And on that POINT should your Report not be based on an SSN Group rather than the TIME Group
    Since I asume SSN is the Student Unique ID?

    Assuming all you are trying to do is get TOTAL time by Student.

    And if this is the case, could you not just Create a Group By Query for the Report

    Grouping BY SSN, Last name, First Name and SUMMING [TIME[

    Then the results could just go in the DETAIL Band.

    Unless I have misunderstood the report requirement.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Mt Macedon, Victoria, Australia
    Thanked 45 Times in 44 Posts
    I attach a demo with two alternatives.
    I am unclear whether you want a total per student per subject, or just a total per student, so the demo has both.

    One issue you will bump into. A time field cannot display more than 24 hours. So if you sum a time field and the total comes to more than 24 hours you will see the wrong result. Anything over multiples of 24 is not display.

    So I usually convert the time field into a number of hours (by multiplying by 24) and sum that.

    Attached Files Attached Files

Posting Permissions

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