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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top