>Greetings,
>
>I am trying to obtain a found set of folks that responded with a
>contribution to not both an appeal sent this year and an appeal sent
>lasy year (not either, but BOTH). Each of these appeals is represented
>by a different source code.
>
>In both FIND mode and doing a query, adding a new request for the second
>source code just yields a batch of people that responded to one OR the
>other appeal, not both as I am seeking.
>
>Any suggestions?
Tricky problem, as you have discovered. Here's one way to do it.
- Create a new field called FLAG or something like that in the names
file. Place it on a convenient layout - Data entry, or query.
- Find the set of people who responded to the first campaign. Use
FileMaker's Replace function to put an x or a 1 or something in the
field Flag in all records of the found set.
- Find again, this time using the x in Flag and the second source
code in the same request.
- You could keep doing this, setting all the Flags in the second
found set to 2, then Finding again for 2 in Flag AND the third source
code for the set of people who had responded to three campaigns.
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
