Cecily, Let me back up a step. Part of what you are looking for is available in the report you are looking for. For instance, the report lists total gift for the year under the YTD $ column. So... if you query the database to find everyone with a YTD $ amount on the home screen of >0, you will have a found set of everyone who has given during the year. That list will be included in the giving level report, but because of the restriction of the member level defined by the "dues" payments, only those who have given a dues payment will be categorized by the member levels.
The piece you want, that of having total gifts define the member level and hence be divided up in the report, will have to be customized. Remember that there are legitimate reasons to define members the way ebase does it. But one program can't handle every need of every user. I for one will be looking at options for how to handle your needs as I can see others may also need to do things that way. If I come up with something, I'll post it. Carl -- Carl Paulsen New Hampshire Rivers Council 54 Portsmouth Street Concord, NH 03301 603-228-6472 603-228-0423 Fax [EMAIL PROTECTED] ------------------ 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 ---------------------------------------------------------------------
