>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. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ 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 ---------------------------------------------------------------------
