I'm trying to query the # of gifts people have given, and if possible, the # of gifts between certain dates. I see "gift amount" as a field under gifts but not "# of gifts" or something like that; any thoughts?

I am trying to create a query that will result in records WITHOUT specific attributes that could be on their records. Because these records have more attributes which are not one of the attributes I don't want, they are being included. I have tried using the operators 'does not contain' and...

Here are last week's most popular Forums posts as well as unanswered posts: Most Popular Topics: transferring to a letter the info found in a donor category report (for donor recognition wall) Marking an email as the preferred email Several criteria for a query HELP??? Unanswered Posts: Advertising...

Kris, the easiest way I have found to create an export of 'unrelated records' is to create a constituent query. Under constituent, I choose "specific record", "one of" and then select the constituents I need. Save the query and use it to create an export file. Hope that helps...

New Batch Types We significantly improved the data import process in this release, including the ability to edit or append constituent data, modeling scores, educational history, and giving summary information. To accommodate these improvements, we added several new batch types: Constituent Update Batch...

For something like this it would certainly be nice to be able to pull a second salutation. Haven't seen that in the mail merge functions. You may need to do an export of data to excel/access to get the second salutation. (Haven't tried to export a donor category other than one from attributes...

[quote user="Andrea Frank"] I am interested in running a query on a gift batch before I commit it. Can this be done? If so, how? Thanks, Andrea [/quote] Nope, From knowledgebase: Solution ID: BB424772 Product: The Raiser's Edge 7 Published: 12/06/2007 Updated: 06/16/2009 Description Unable...

I think I am just having another Monday morning but I am totally stressing over the queries that I have to provide to the ED today. We are going to be mailing a letter to the following and need to get a listing to her. Below is the criteria that she is needing and I think I am confused and totally stressing...

I am interested in running a query on a gift batch before I commit it. Can this be done? If so, how? Thanks, Andrea

I am trying to send out letters to all of our donors to our last capital campaign asking them to verify how they want their information listed on the new donor wall. I used a Donor Category Report to get all the names in the different categories and the total amount that each donor gave. The letter,...