Thank you - now I know which is the "or" request. But, is there a way to do an "or" request so I can have who gave $ in '00 or '01 in one found set? I want to print labels/send letters and I know there will be dupes if I use 2 separate finds. ( I hope I'm being clear..) Thank you so much jana -----Original Message----- From: Walt Daniels [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 8:44 PM To: TechRocks Support Subject: [support] RE: query/finding '01 & '00 donors Query is just a script that uses Find, the underlying FileMaker command. Its main advantage is that it exposes some fields that are not on the other layouts. 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. > -----Original Message----- > From: pwf [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 12, 2001 7:00 PM > To: TechRocks Support > Subject: [support] query/finding '01 & '00 donors > > > Hi, > I want to find all '01 and '00 donors. I performed both a find and a query > (to experiment because I'm new at payment finds) and put ">0" in the "YTD" > field, then added a new request and put ">0" in the "Last Year" > field. Both > found 192 records. Is this the correct way to find everyone who donated in > those 2 years? > > On the otherhand I did a Payment Query, again putting ">0" in the > 2 fields, > as two separte requests, and it found 908 records. What did this query > actually find? > > Thanks very much > > 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 > > > ------------------ > 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 --------------------------------------------------------------------- ------------------ 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 ---------------------------------------------------------------------
