Duplicate Labels

[Guest_imported]

This is a survey DB...it links the people rating to the person they are rating.<br>The report's record is linked by SSN.&nbsp;&nbsp;When you click next record...it will show all rows in the table that have that same SSN(the person being rated). The problem i'm running in to is that, there's a lot of fields on the report and rather than having it display horizontally across into many pages.&nbsp;&nbsp;I was hoping to have it grouped vertically to fit all rows related to that SSN fit on one page.<br>I need it to look like this under Details<br>ex) Mike and Paul are the raters, they're linked to the person being Rated by SSN.<br>The Report: This is what i need it to do<br>(Labels)-&gt; 1 2 3<br>Mike&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A B C (the reponses)<br>Paul&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B C D<br><br>&nbsp;(Labels)&nbsp;&nbsp;4 5 6<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;X Y Z (response for fields 4-6)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Y X Z<br><br>But it keeps duplicating the labels 1-6 for Paul also(labels)-&gt; 1 2 3<br>Mike&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A B C (the reponses)<br>(labels)&nbsp;&nbsp;&nbsp;1 2 3<br>Paul&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B C D<br><br>(labels)&nbsp;&nbsp;&nbsp;4 5 6<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;X Y Z (response for fields 4-6)<br>(labels)&nbsp;&nbsp;&nbsp;4 5 6<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Y X Z<br><br>How Do I get rid of this Dup, since the labels represent Questions...it be repetitive to list the question again for another Rater.<br>Any help would be great <br>thanks,<br>

 

[DougP]

Open your report in design view thenm have a look at &quot;Sorting and Grouping&quot; under the &quot;View&quot; menu <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.