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