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. Dave, thanks very much for this. I did this initially but thought it was an "and" rather than an "or" search. Yes, I do need to brush up on my find techniques. thanks you jana -----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 ---------------------------------------------------------------------
