This very well might be an inefficient way to do this but maybe it could help you out: do a query of greater/equal to for one entry date, then less/equal to for the other date. then gather the overlapping entries .
good luck. hopefully someone else hhas a better idea than this! Nikki Zeichner on 2/19/02 1:10 PM, Holly Ross at [EMAIL PROTECTED] wrote: > I have a puzzler for all you ebase code fiends! > > I'm working with a group that wants to do a specific search: anyone who made > payments in a specified date range (like 1/1/2001 through 7 /1/2001, or > 2/5/2002...2/19/2002) with a CUMMULATIVE total of $X or more. > > Carl really came through on my last stumper. Anyone up to this challenge? > > > > ------------------ 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 ---------------------------------------------------------------------
