Hi Duncan,

What information are looking for?  What do you want to do with it: view it, export it, create a mailing or report?  What query type are you using?

jwant

Type: Constituent

Finding donors whose last gift was within last 2month. the result shows some rows are duplicate- exactly same. I can get rid of duplicates in Access, SQL Server or Oracle but how to do in RE? Thanks.

Duncan,

Which fields are you including on the output tab of your query?  Try removing all of the fields except constituent ID from the output tab.  What do you want to do once you find these donors?

jwant

Sometimes it's easy to figure out why there are duplicate rows (looking at gifts and donor has more than one or output field has potential for more than one entry - ex: phone, attribute, code) and other times it's a challenge.  As Jason suggested, removing output fields may resolve issue. Sometimes check box for "Suppress Duplicate Rows" feature under Tools >> Query Options >> Record processing helps.

But as many trainers/instructors stress:  "Query is not a report module".    It may be easiest to save your query and then go to export and create an export based on your query.  Each constitutent will only be listed once in the export.  You will need to select whatever fields you wish to export.  Query only identifies which records to export not which fields.

Good luck.