Hi - I am trying to remove duplicate rows in a report. The thing is that the row itself isn't truly a duplicate. What I have here is a report on how a student did on a math test. I want to create a report that lists out all the skills that were missed. Each question is tied to a specific skill, so behind the scenes the table has a separate row for each question the student got wrong. What I want to have is for the 4 visible fields, if the first visible field is the same (in this case, the column "Areas Proficiency Not Demonstrated") then the rest of the rows with the same detail is suppressed. I tried the Hide Duplicates property but all it does is hide the words - there is a bunch of extra space and rows aren't compressed.
This actually works great if I do a grouping by the Skill field (the field for the Areas of Proficiency Not Demonstrated), but the other piece I have to do is only list the top 15 records per student, so that is why I need to have this information on the detail section as opposed to another grouping field or else the VBA for counting the records then hiding the rest doesn't work properly.
Any suggestions would be helpful!
This actually works great if I do a grouping by the Skill field (the field for the Areas of Proficiency Not Demonstrated), but the other piece I have to do is only list the top 15 records per student, so that is why I need to have this information on the detail section as opposed to another grouping field or else the VBA for counting the records then hiding the rest doesn't work properly.
Any suggestions would be helpful!