I am trying to find all donors who have given at least one gift of $100 or more for a tribute that they are connected to. I am having a hard time coming up with the correct results. I keep getting all relationships and not just the one of $100 or more. Can some one give me a clue?

Kathy,

 What have you tried?  What type of query are you using and what are the criteria you put in it?

I would suggest a gift query, but I am guessing you'd want a consituent query.  Try this:

(Gift amount greater then or equal to $100
AND honor/memoial name not blank.)

I don't know that you really need the ( )'s  put just in case.

Melissa,

I used the query of gift date between (....) and Tribute type = InMemoryOf

Gift amount greater than or equal to $100.

This is using an Individual query type. I get all the gifts for last year that were in memory of someone and greater or equal to $100. If I then try to see if there is any relationship between the donor and gift tribute, I get alot of "stuff". I need to know if anyone with a relationship to a deceased gave more than $100 in memory of them last year.

I hope I'm not making everyone more confused....

I am now more confused about your problem.  I thought you originally said you could not limit it to 100 or more.  Have you fixed that and now have a problem adding relationships to your query output?

If you using an individual query and are adding relationships that is a one-to-many field and you will get a row added for every relationship on that record.  That is supposed to happen as query is not a reporting tool. 

You should be able to see the donor's name by just outputting the name field - you can also add the tribute name field - why do you want to add relationships?

Melissa

Kathy Yopp:

I need to know if anyone with a relationship to a deceased gave more than $100 in memory of them last year.

You cannot do this from the RE front end.  It requires comparing two fields to each other (deceased ID) and (tributee ID).  RE will only let you compar