For my quest to find everyone who donated in '00 or '01, I received these 2
emails below in response to my "please help" emails, but they seem to
contradict each other. Can you clear this up? Thank you very much for all
your help.
1)."Use the Query tab, and click to Screen 2, Donor
Enter >0 in the YTD$ field
Click the New Request button.
Enter >0 in the Last Year $ field.
Note that you are not doing a second search, you are doing a single
search with two criteria. This results in a logical OR search - every
record will be someone who has donated in 2000 OR in 2001. You won't
get duplicates, since everyone is in the names file only once. If
someone has donated both years, there will be a record in the found
set with a dollar value in both fields."
***************************
2)."Doing one request and adding a second request is an AND request. So you
got
those who gave both years. Doing the separate requests (presumably you added
the numbers in your head)is an OR request"
Jana Reister
Professional Women's Fellowship
1013 - 8th Ave
Seattle WA 98104
ph 206-382-7276
fx 206-382-0810
[EMAIL PROTECTED]
www.pwfnw.org
-----Original Message-----
From: Dave Shaw [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 4:28 PM
To: TechRocks Support
Subject: [support] Re: another ? on finding '00 donors
>More discoveries to add to: (thanks. But I was searching for any >0 value
in
>the "Last year total" box on
>the Payments screen, which is a sum of contributions in '00,a $ amount, not
>how many times they gave, yes?. So, am still perplexed why this is finding
>more folks than doing the same on the Home screen using the "Last year $"
>box.)
>
>But, when I do the same 2 (separate) finds for THIS year, putting >0 in
the
>YTD$ box on Home and >0 in the "YTD Dues/contributions" on Payments screen,
>I get the same number of names in the found set, which is great. Why
wouldnt
>it work for Last year too?
Coincidence, that you happen to have only one payment per person for
this year's donations. You must be aware of which file you are in,
and what the resulting set is - payments or people.
>
>Also, for my found set, using the Home screen, I performed the FMPro
>Replace script (hopefully correctly) and put an "x" in the Status box on
>Data Entry screen, which is cool. But this find didnt seem to find ALL '00
>donors. When i pull up a name that I know gave in '00 (and payment shows in
>Payments), but wasnt included in my found set, then I do a Find All again,
>redo the find for '00 donors, the name DOES show up in the list then but
>with no "x" in the Status box (obviously). Why did it find it later? So
>confused, as may be this my email.
Sounds to me as if you didn't do the replace correctly.
Let me offer a potentially simpler way to do the find, in one step so
you don't have to worry about using the replace.
What you are looking for is people, so do the find in the names file.
Use the Query tab, and click to Screen 2, Donor
Enter >0 in the YTD$ field
Click the New Request button.
Enter >0 in the Last Year $ field.
Note that you are not doing a second search, you are doing a single
search with two criteria. This results in a logical OR search - every
record will be someone who has donated in 2000 OR in 2001. You won't
get duplicates, since everyone is in the names file only once. If
someone has donated both years, there will be a record in the found
set with a dollar value in both fields.
Hit the continue button to perform the search. The found set will be
the list of people (not payments) who donated in 2000 or 2001 (or
both).
This is a concept beyond the beginner level, certainly. I recommend
reviewing the ebase manual and the FileMaker manual for details on
performing searches. There are examples there which I think will help
illustrate the kind of search you're attempting.
--
--
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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
