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