>We are trying to find information on how to do very specific queries. >There seems to be no list of instructions anywhere for confused people! Searches can be very complicated. There is lots of good information in the FileMaker manual on this. >We >would like to do a query of people who have made donations of over $99 (at >least a SINGLE contribution of $100 or more, not a total) since January 1, >1998. We keep getting people who do NOT fit the criteria even though we >use the AND query not the OR query. HELP! You should be in the payments file; the , and click the gray Find button. Enter >99 in the amount field, and >1.1.1998 in the post date field, and click the Find button in the gray area on the left. Putting both entries on the same find request is how you do the logical AND search. > >------------------ >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 ---------------------------------------------------------------------
