Number 1 is the correct answer.
The AND vs. OR logical operations stuff is fundamentally different in
FileMaker vs. Access, for instance. This is where this confusion probably
originated. The Number 1 poster (Dave Shaw, I believe) has done a good job
in describing how the FileMaker/ebase logic works.
To get those who donated in both years ONLY, you would need to enter data
into both fields on Query Screen 2, on the same screen, without clicking on
"New Request." This would be the AND type of query. To extend Dave's
explanation to this situation, such a query would show every record with
people who have donated in 2000 AND 2001.
Barry Madore
> From: "pwf" <[EMAIL PROTECTED]>
> Reply-To: "TechRocks Support" <[EMAIL PROTECTED]>
> Date: Mon, 17 Sep 2001 10:54:29 -0700
> To: "TechRocks Support" <[EMAIL PROTECTED]>
> Subject: [support] AND vs. OR request
>
> For my quest to find everyone who donated in '00 or '01, I received these 2
> emails below in response to my "please help" emails, but they seem to
> contradict each other. Can you clear this up? Thank you very much for all
> your help.
>
> 1)."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."
> ***************************
> 2)."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"
--
Barry Madore
Technology & Web Development Specialist
MAP for Nonprofits
Direct: 651/632-7235
MAP: 651/647-1216
email: [EMAIL PROTECTED]
MAP web: http://www.mapnp.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
---------------------------------------------------------------------
