Tres cool! Thank you very much.
Peace,
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: Walt Daniels [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 11:41 AM
To: TechRocks Support
Subject: [support] RE: query/finding '01 & '00 donors
Do one find. Do an FMPReplace script on some unused field(i.e. blank text
field) with X.
Do the other find and and FMPReplace again with X.
Do a find for X in that field. That will have no duplicates.
When done, clear the field back to empty so you can use it again the next
time you need to do this sort of thing.
For most people the Status field on the home page is unused (at least the
base system does not use it). However you are on a Payments screen so you
need to reference that field though the names relationship.
> -----Original Message-----
> From: pwf [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 11:52 AM
> To: TechRocks Support
> Subject: [support] RE: query/finding '01 & '00 donors
>
>
> 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
> ---------------------------------------------------------------------
>
>
------------------
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
---------------------------------------------------------------------
