From Liz Gans at TechRocks... >-----Original Message----- >From: Liz Gans [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, March 06, 2001 9:15 AM >To: 'TechRocks Support' >Subject: RE: [support] RE: Query Assistance... please > > >Jeremy, >We are in the process of re-thinking the way we deliver documentation on >ebase, and your suggestion is most welcome! Thank you. > >Your comment suggests to me that however we deliver the documentation--as a >user manual, individual FAQs, QuickTime movielets, etc.--it would be helpful >to users if we organize (and title) parts of the documentation to fit the >common kinds of tasks/queries that users need to perform "How to find all >payments for 19__ to 20__ in excess of $99". > >As we get further into the documentation re-design, I'd like to check out >some ideas with you. And any others who have suggestions, please forward >them to this list or to me directly at [EMAIL PROTECTED] > >Thanks, >Liz Gans >Director, ebase Community Support >TechRocks >[EMAIL PROTECTED] > > >-----Original Message----- >From: Jeremy Marin [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, March 06, 2001 8:35 AM >To: TechRocks Support >Subject: [support] RE: Query Assistance... please > > >Walt, > >I appreciate your suggestion. Unfortunately I was trying to do this through >the "query" screen rather than "payment". > >For future reference, I have received several personal e-mails from people >who have similar issues with e-base (ie-performing what should be simple and >regular queries). It would be nice if on the Help page there were a list of >basic queries people will need for any organization which lay out, >step-by-step, the process to complete these functions. > >Thanks, > >Jeremy > > > >-----Original Message----- >From: Walt Daniels [mailto:[EMAIL PROTECTED]] >Sent: Sunday, March 04, 2001 6:33 PM >To: TechRocks Support >Subject: [support] RE: Query Assistance... please > >Unless I missunderstand your problem, it is completely straight forward. I >went to the Payment entry screen and put the date range in the Post Date >field and >=100 in the amount field (assuming you don't want to find someone >who gave $99.50). This does not get people who gave a bunch of small >donations that total more than $100. Changing the fiscal year trick only >works if you want to deal with exactly one year's worth of data. That would >allow you to get the sum of small donations. Going beyond this almost >certainly requires writing a script or doing the date ranges in 1 year >pieces. > >> -----Original Message----- >> From: Jeremy Marin [mailto:[EMAIL PROTECTED]] >> Sent: Friday, March 02, 2001 11:30 AM >> To: TechRocks Support >> Subject: [support] Query Assistance... please >> >> >> Our organization has been struggling with e-base for some time now and >> consistently have problems. If anyone who can help with our current >> problem I will be eternally grateful. >> >> I am trying to find donors who have: >> donated between 1/1/1998...3/2/2001, and, >> donated more than $99. >> >> I have entered these items in the query form, view #2 (date in the "post >> date" field, dollar amount attempted in both the "amount" field and the >> "max gift" field.) No success. I keep pulling up people who have donated >> less than $99 in that time frame. >> >> I have tried the same within the "Find" "Payments" screens, again, no >> luck. >> >> Reviewing past questions on the listserv a similar question was answered >> saying that a "tricky" way to do it is by changing the "definition of >> fiscal year to the desired calendar range in the setup file." but I do not >> know how to do this. Obviously, if there is an easier way to fix this I >> would prefer that. >> >> It seems that this SHOULD be a simple query which organizations must ask >> regularly. >> >> Thank you for all help/suggestions, >> >> Jeremy >> [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 >> --------------------------------------------------------------------- >> >> > > >------------------ >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 >--------------------------------------------------------------------- -- Dave Shaw Northwest Classics, Inc 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 ---------------------------------------------------------------------
