[Randi]

Trying to run a query to weed out all the constituents with whom we have not had any contact for three or more years. My criteria was "last gift date less than 1/1/2005" AND "last action date less than 1/1/2005" - yet there are people not showing up who have not had an action or gift since 2000.

Any ideas?

[Melissa Siobhan]

What are your query options for soft credit options?

[Randi]

Hard credits - this is a recent migration into R.E., so there isn't anything with a soft credit prior to 2007.

[Melissa Siobhan]

sounds wierd.

I am assuming you have looked at those misisng people's records and checked to see if there is any common issue (inactive, deceased, etc.)

hmmm

The only thing I can think of is that I ususally prefer querying on summary giving to querying on last gift date. So I would use total gift amount greater than 1/1/05 = $0 and see if that makes any difference. It shouldn't but who knows.

[Randi]

I'm going to try that - thanks!