>I apologize for asking what is probably a rudimentary question: how >can I do a search for members whose dues payment has lapsed or is in >the grace period and ONLY get records for the last payment? > >When I do the search, using the Query tool and first selecting >"members: lapsed" and then adding a new request with "members: >grace," the file that I export (for a letter merge) has the records >for the people that I asked for, but it also exports the payment >info. for each payment that member has ever made. This means that >when I do the merge (in Word), there is a record for each person and >each payment made, when what I really want is only the record for >the person with his or her last recorded payment. > >Make sense? What Find criteria do I need to add? Thanks very much,
What I think is happening here is that you are searching in the payments file. In this case you are searching for people, not payments, so you should search in the names file. if you search in the names file for Member Status = lapsed or Member status = grace, you should get the set you are looking for. -- -- 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 ---------------------------------------------------------------------
