Building a report in Access 07 and I don't want duplicates in the first column. So I click on the data item in design view but that highlights both the data item and the label at the top of the report. I open the Property Sheet and select YES by Hide Duplicates but, when I open the report, the duplicates are not hidden.
Is there someway to isolate the data item and not highlight the lable and actually hide the duplicates?
Thanks