>I want to find all '01 and '00 donors. I performed both a find and a query
>(to experiment because I'm new at payment finds) and put ">0" in the "YTD"
>field, then added a new request and put ">0" in the "Last Year" field. Both
>found 192 records. Is this the correct way to find everyone who donated in
>those 2 years?
Yes, using two separate find requests accomplished a logical OR
query. That is, every record is someone who donated in 2000 OR
donated in 2001.
>
>On the otherhand I did a Payment Query, again putting ">0" in the 2 fields,
>as two separte requests, and it found 908 records. What did this query
>actually find?
>
Since this query was done in the payments file, in this case you have
found all the _payments_ made by people who donated in 2000 OR
donated in 2001. Since each person can have more than one payment,
you will find a larger number of payments than you did of people.
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------