>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. Thanks for your help! Regardless of the field you searched, the result is a list of _payments_ that satisfy your search criteria. Your search for the summary field (which lives in the names file) while in the payments file gives you startling results. Your search was in effect for "payments whose related name record had >0 in the last year$ field". Note that if an individual had three payments in 2000, $100, $50, and $25, the Last Year $ field will show $175 in each of those payment records, since each payment record is related to the same name record. So your search for >0 in the payments file will find all three payment records, not a single name record. If you do the same search in the names file, you will find only the single name record. Make sense? > -- -- 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 ---------------------------------------------------------------------
