Eliminate Duplicate records in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Looking for a way to eliminate duplicate records by line in a report. I have
found the 'hide duplicates' in the properties for a particular field, but I
would like to eliminate the entire line in a report based on the duplicate
record in one of the fields-and not leave a blank white space-try to cut
total length of the report. Being somewhat new to Access, how can I
accomplish what I am trying to do?

Thanks
 
The solution really depends on what is causing the duplicates. Check the
join in the recordsource and make sure that it is correct. You can try
changeing the query to select only distinct records. If you are still having
trouble, you probably need to use a subreport. Modify the main report's
query to eliminate the many-side table and create a new subreport to display
the many-side data.
 
Back
Top