Marya,
This may be the old problem with the SUM::CurrentFiscalYear field. See
the fix below and try it out. If you want to confirm the problem first,
try finding a few records where the problem occurs, then run the Replace
Current Find Fields script from the Script menu for each of those
records and see if the find you're having problems with works properly
for them. If you have problems with following this, feel free to call.
Carl
>From Jack Noll:
Peter Trosclair reported a problem recently. He was getting one result
when he ran "Replace All Find Fields", yet getting different results
when
he ran "Replace Current Find Fields". There was a bug in a field
calculation that was the culprit.
You should determine if you have this problem. Get into ebase using
your
master password. Once you're on the HOME screen, select
File->Define->Fields. Double-click on the field named "SUM::Current
Fiscal
Year". You will see a "Specify Calculation" dialog box appear.
The correct calculation for this field is as follows:
If( Month(gToday) >= setup::Fiscal Year Number and setup::Fiscal Year
Number > 1, Year(gToday) + 1, Year(gToday))
If the calculation for your field reads differently, you should correct
it. After doing so, you should run the "Replace All Find Fields"
script,
leaving the date blank so that it runs for your entire file.
Carl
--
Carl Paulsen
New Hampshire Rivers Council
54 Portsmouth Street
Concord, NH 03301
603-228-6472
603-228-0423 Fax
[EMAIL PROTECTED]
Marya Bak 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]
