Hide duplicate data in a report

You can hide duplicate data on a report with sorted records or on a report with grouped records.

Hide duplicate data on a report with only sorted records

1. Create a report that sorts records on one or more fields that might contain duplicate values.

   How?

2. In report Design view, place the text boxes for all the fields in the detail section.
   
   
3. To display the property sheet for a text box that contains data that might repeat, make sure the text box is selected, and then click Properties on the toolbar.
   
   
4. Set the HideDuplicates property to Yes.

   Note   In any text boxes for which HideDuplicates is set to Yes, Microsoft Access prints a value in the first record in which that value occurs and, if records with the duplicate value continue onto another page, at the top of a new page.

Hide duplicate data on a report with grouped records

1. Create a report with one or more group levels.

   How?

2. In report Design view, move the text box for the field you're grouping on from the group header to the detail section.
   
   
3. To display the text box's property sheet, make sure the text box is selected, and then click Properties on the toolbar.
   
   
4. Set the HideDuplicates property to Yes.
   
   
5. Remove lines and all other controls from the group header.
   
   
6. Double-click the section selector of the group header to display its property sheet.
   
   
7. Set the Height property of the group header to 0.

   Note   The group name will appear only at the beginning of a new group or at the top of a new page if the group continues for more than one page.