Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicates

Status
Not open for further replies.

kevykevg

Technical User
Jun 5, 2006
50
US
I am looking for a simple CR 11 formula that will remove duplicates from a field and will only show distinct records.

 
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.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top