You might group by the field that is duplicating and place the fields in the group footer and suppress the details and group header sections.
True duplicate data can be removed by using Database->Select Distinct Records, but that's probably not your issue, you probably have row inflation, which has to do with how the tables are joined, and has nothing to do with distinct records.
You've posted nothing about the tables used, the database, or anything technical so the above solution probably suits your level of experience well.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.