Hide Duplicates

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I would like to make a report of items linked to a many
table and report only one instance of the item. I know I
can hide duplicates in the format properties of the text
field, but even then there is blank space under each
record that is as big as if the duplicates were listed.
Does anyone know how to eliminate the space that the
duplicates occupy?
 
You can do two things,
1. Set the can shrink property on your report to yes, and
set the can shrink property for the text box to yes.
2. If your report is based on a query you can set the
properties for the query to set unique values to yes.
Hope this helps.
Fons
 
Back
Top