DonorWise TM
Enhanced communication with donors, enhanced ministry credibility...
Successive Lookups

Contents

 


It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare

Syndication

Successive Lookups

Print this Topic Previous pageReturn to chapter overviewNext page

Successive Lookups

Multiple lookups can be run in succession to narrow down the results. For example, successive lookups could be written to find just donors, then among those donors who live in a certain city.

Writing a Successive Lookup

In this example, we want to find all donors who have given at least 100 in the last year and live in a certain city.

1.Lookup all donors in the city.

Menu Path: Lookup | By Field

Relationship

Replace the current group

Field

Mailing City

Comparison

begins with

or

is exactly

Value

Enter the name of the city or select it from the drop-down list.

Press the <OK> button.

The <Current Group> is now all contacts whose mailing address is in that city.

2.Find within that group those donors who have given 100 or more last year. (Note that DonorWise interprets this as given any single gift of 100 or more, not total giving of 100 or more).

Menu Path: Lookup | Donor | By Donations Given

Relationship

Lookup within the current group

From

Enter the start date (such as January 1)

To

Enter the end date (such as December 31)

From Amount

100

To Amount

Leave blank. This tells the software to find any amount above 100.

Result

The Current Lookup shows two filters and the resulting Current Group.