Actually, I think these are two separate problems.
For donor status, be aware that when you enter "Lapsed" in the query screen, this
refers to members who are lapsed. But what you are finding is not members, but
payments. And the payments themselves also have a field called status, which is
different. Basically, the status field on the Payment Entry screen shows what the
member status would be if this were the last payment. Silly, I know, and I've taken
it off my layouts because it's confusing for people.
But how could you be finding current payments if the member is lapsed? Well, the only
thing I can think of is that the Member Status field looks at the last payment in
terms of Post Date. So if you had a payment that had an earlier post date but whose
membership lasted longer than one with a later post date, you could have a mixed up
Member Status. Try your query again and see if you have any data entry errors in the
dates. In general, you should try not to change the Start Date values that pop up
when you add a new membership payment, which will make sure that new memberships begin
as the old one ends.
As far as the date ranges go, you need to use three dots ("..." without quotes)
instead of the dash. If you're using FMP 5, entering a date as 00 should be ok, but
if this still doesn't work try using 2000.
Let me know if this works.
HTH,
Matt
At 04:50 PM 11/13/00 -0500, you wrote:
>
>Hi Matthew-
>I'm performing the query from the payments file. Under the query
>screen I click on "Donor Status" and select "Lapsed", then in the
>"Amount" column I enter "<$100". The results do not correspond with
>the query. I get back results which include current, lapsed, and
>grace members. Additionally, I am unable to perform queries using
>the year "2000". For example, I may try to find all individuals that
>donated money from "1/1/99-1/1/00" (I enter this in the "post date"
>box). Ebase does not understand the "1/1/00". To me, it seems as if
>these two problems are related. Can you help?
>Any advice would be appreciated.
>
>>Are you doing the query from the payments or the names file?
>>
>>How are you indicating the AND in your query? Are you hitting the
>>New Request button?
>>
>>
>>
>>At 05:00 PM 11/9/00 -0500, you wrote:
>> >Hi-
>> >
>> >I would like to mail out a renewal letter to all of our members who
>> >currently have "lapsed" and "grace" status. I keep performing
>> >queries to find all of these members, and the results do not match
>> >with the query that I performed. For example, I tried to search for
>> >all members with "grace" status that have donated less than $100.
>> >The results that I get included current, grace and lapsed members.
>> >Can someone help? Is there a better way to do this?
>> >
>> >Sincerely,
>> >
>> >Marya Bak
>> >Administrative Liaison
>> >National Wildlife Refuge Association
>> >1010 Wisconsin Avenue NW Suite 200
>> >Washington, D.C. 20007
>> >202-333-9075 office
>> >202-333-9077 fax
>> >[EMAIL PROTECTED]
>> >
>> >
>
>
Matthew Scholtz
Evaluator and IS Coordinator
Health Initiatives For Youth (HIFY)
www.hify.com
