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 ---------------------------------------------------------------------
