With The Raiser’s Edge, you can avoid displaying duplicate information in query results by performing the suppress duplicates task. In Query, duplicates are defined as two or more lines on the Results tab that contain the same information.

Example: Create a constituent query to find all constituents that gave within a specific date range. If the option is unchecked, a constituent has given more than one gift, and we are outputting constituent name or constituent ID (which are not one-to-many fields), we will see this constituent for each gift they have given. If we run the same query, but we check Suppress Duplicate Rows, The Raiser's Edge changes how it processes the query, so that we should only see the constituent once in the results.

For more information on Query duplicates, review Why are there duplicates in the query results and how to remove them (BB61118).