We had a consultant import some legacy payments for 97-2000. I did a query to find anyone who's donated in the last three years - 99, 00, 01. I got 317 names. To double check, I did a "find" using a field on the data entry screen where I actually have typed in "99", "00", "01", etc for whatever years someone has given. That list gives me 328.
I've discovered that the 11 names that aren't showing up on the query are part of the group w/imported payments, but only w/payments from '99 or earlier. Seems the query just recognizes those w/imported payments that also have payments from '00or '01 that I've input myself. Any ideas on how to get the query to recognize what it should? Hope this is clear. Thank you. Jana Reister 206-382-7276 -----Original Message----- From: Jana Reister [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 3:16 PM To: [EMAIL PROTECTED] Subject: Fwd: Hi, Frank >From: "pwf" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: Hi, Frank >Date: Mon, 17 Dec 2001 14:21:55 -0800 > >I hope you are well! >Quick question for you (I actually asked this a couple months ago...maybe it >doesn't have an easy answer?): > >Regarding the legacy payments you imported for us for '97-'00 - >I did a query to find anyone who's donated in the last three years, 99, 00, >01. I got 317 names. To double check, I did a "find" using a field on the >data entry screen where I actually have typed in "99", "00" etc if they >gave >in those years. That list gives me 329. > >So, I've noticed that the names that aren't showing up on the query (but >indeed should) are those w/payments you imported. >I need to know why. I'd love to discontine my manual method where I do a >"find" and just use the query but clearly I cant until this is solved. > >Any ideas, Frank? Or do you suggest I float this one to the Ebase Support >folks. Thought I'd go to the source first. >Thank you so much for your help. > >Jana Reister >Professional Women's Fellowship >206-382-7276 >[EMAIL PROTECTED] > _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com ------------------ 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 ---------------------------------------------------------------------
