Walt,
Thanks so much for your clear answers. I do have FMPro and will construct a
report just like what I need.
But about the query, my fault for not being explicit. I want to do an
across-files query.
Here's the setup. I query the payments file for all payments for dues in
March. I want to email the found set, but when I go back to the names file
to query for names with email addresses, I lose the payment found set.
Hmmm. Just thought of something. I haven't tried the query starting from the
Names file, searching for those with email addresses first.
Would that work?
Marion
----------
>From: "Walt Daniels" <[EMAIL PROTECTED]>
>To: "TechRocks Support" <[EMAIL PROTECTED]>
>Subject: [support] RE: Comprehensive report
>Date: Fri, Apr 20, 2001, 5:03 AM
>
>>
>> 1. Is there a way for me to save query results for future use?
>>
>
> Saving query results is not a good idea as the saved result would not be
> updated by changes that are made during the time that you save them. It is
> better to save the query formulation unless it is a trivial one. There is a
> whole screenful of custom queries that can be set up. They are actually
> saved to a certain extent. If you do a find and then exit ebase, the next
> time you bring it up on that machine you will be looking at the last found
> set.
>
>> 2. Do I have to export data to Excel from the payments and name files in
>> order to generate a single report for multiple contacts that includes
>> payment information (like when, what for, pay method, thank date)
>> AND member
>> name, business, email, phone, fax, and address?
>>
>
> There are two ways of producing new reports besides the built-in ones. If
> you own FileMaker you can write your own custom reports. If not your best
> bet is to export the appropriate data and use some other program that you do
> have, e.g. Excel, to produce the report.
>
>
> ------------------
> 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
---------------------------------------------------------------------
