I don't believe the fields you want currently exist in ebase. Find $LY and YTD$ provide a summary of dues and contributions for last year (calendar or fiscal depending on how you set up the fiscal year in the Setup routine) and for the year to date. Both combine dues and contribution, unless someone has modified ebase.
To get summaries for just dues or contributions for last year or this year, you'll need to do some fancy footwork to create these fields. You may be able to use the "Dues" and "Contributions" relationships to create found sets for payments last year and this year, and then do some math on these found sets. Better would be to duplicate and modify the relationships "Payments Last Year" and "Payments Current Year"using relationship keys that filter for just dues or contribution payments. Then mimic the ebase fast find fields for $LY and $YTD. If you don't understand what I'm suggesting, you'll probably need help making this modification. But maybe I'm missing something... Carl Beth Hynes wrote: >Hello all, > >We are sending form letters (MSWord) to current members and want to show how >much they gave in 2001 in two fields: dues and donations. I found a field to >export that gives me last years total of dues and donations (Find_$_LY) and >just donations (YTD$), but nothing about just dues. > >I've looked in the data dictionary as well as all over the place within >ebase and can't find a field that shows just dues except Last Amount- which >shows the last dues the person gave regardless of the year. That won't do >:-) > >Any suggestions? > ------------------ 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 ---------------------------------------------------------------------
