1 Reply Latest reply on Jun 24, 2009 12:28 PM by Pine

    Sub-summary reports show only one item per student

    Pine

      Title

      Sub-summary reports show only one item per student

      Post

      I have a database tracking students who receive grants. They then have to seek work, or actually work, to pay back their grant obligation.

       

      My sub-summary reports look OK, but I just realized that they aren't working as I want and need them to work!

       

      One report deals with letters. There is a table called Letter, with a pk key field of letter_id. A student may have been sent zero to many letters, with one letter of each type. The field letter_type has 10 items in a value list. My sub-summary report shows and sums up the number of students who received each of the 10 letter types - EXCEPT that I just noticed that each student is listed only once, as having been sent one type of letter, even if they received multiple letters. 

       

      The goal is to show a summary of all letters sent, so students should be listed under three "value list choices" (letter types) if they were sent three letters. Letter_type is not a repeating field. Should it be? Is there some other solution?

       

      Thank you!