correct. what i hoped would show up based on my search criteria is anyone who gave $1-24 for 2001 or 2000 or 1999. unfortunately, what showed up was someone giving $15 in 2001, $40 in 2000 or $35 in 1999, which falls out of my dollar range of $1-24.
Searches are complicated when you start to deal with logical ANDs
and ORs.
Your find criteria will give you the set of people who gave
$1-$24 in 2001, or who gave $1-$24 in 2000, or who gave $1-$24 in
1999. Your example satisfies one of the three criteria, that is,
$1-$24 in 2001.
It sounds like what you want to do is find people who gave $1-$24
in one of the three years, but no more in any of them. If you want to
exclude any records with more than $24 in any year, you need to add
three more find requests, each with >24 in one of the years, and
the Omit box checked.
thanks-
----- Original Message -----From: Dave ShawTo: TechRocks SupportSent: Friday, April 06, 2001 10:24 AMSubject: [support] Re: Giving History Reporting
I'm trying to run a search/find for various giving levels for the last 3 years and its not working. This is what I'm doing:
1) Run my search in Query: Screen 2 Donor info
2) Create 3 request, the first one in YTD field asking it to search for anyone giving 1.00...24.00 (using the 3 periods for range). I use the same range amount for the next 2 request only I put it in Last Year and Previous Year fields.
It appears to do my search with no problems, but when I pull the report I see donors/members who have giving over my amount range (i.e. $40.00) for one of the years specified (i.e. YTD, LastYear or Previous Year). I hope I don't have to run a search/find for each of my giving levels (total of 4) for each year (total 3 years) which would mean I would have to run 12 individual reports.
Help, what am I doing incorrect?
The search you specify above will find anyone who gave between $1 and $24 this year, OR who gave the same last year, OR who gave the same the previous year. So, if I gave $20 this year and $40 last year, I'll be included on the basis of the $20 this year, even though I gave a different amount in the other years. Is that what's happening?
Thanks,
Cathy M. Elizondo
Outreach Coordinator
Snake River Alliance
Idaho's Nuclear Watchdog
tel: 208/344-9161
fax: 208/344-9305
http://www.snakeriveralliance.org
------------------
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
---------------------------------------------------------------------
--
Dave ShawNorthwest Classics, Inc tel: 206-954-7526 fax: 206-625-1338------------------Reminder to each recipient: To change your list account preferences, go tohttp://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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
------------------ Dave Shaw
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
---------------------------------------------------------------------
