oops sorry, two threads quite intermingled, guess I have a cold too Peter Kidd wrote:
> sorry I forgot we are currently only handling contributions, so these > kinds of queries are a cinch! > > wash my keyboard with soap, but if all else fails, export the > necessary data to a spreadsheet, where further analysis would be much > easier (for me at least) than calculated keys and sum() > > alternatively, you could temporarily populate a Custom Field with the > Date of Last Donation (a replace), and do a simple Find using the two > fields (now identical data under the same relationships I think) but > find for 2000 in one field and 2001 in the other field > > Dave Shaw wrote: > >>> Although... >>> How can I use that field (or set up a new one) to tell me who gave >>> $1000 or more from 1/1/01-9/30/01. The setup does not allow this a a >>> fiscal year choice as it only >>> allows you to set the start month. >>> >>> Any thoughts? >> >> >> >> You'd have to set up a relationship with calculated keys that include >> the dates. Then use a SUM() function to accumulate the totals. Sounds >> complicated. >> >> Depending on how many records you're talking about, it might be >> possible to search for payments in the date range, run a Payment >> report, and simply scan the individual totals for those over $1000. >> > > > > > ------------------ 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 ---------------------------------------------------------------------
