Replies

Seeing how you want to know how many contributors ALWAYS contribute at least $1000, try this:

SELECT [ContactID], Min([Contribution]) AS MinC FROM [Contributions]
GROUP BY [ContactID] HAVING Min([Contribution]) >= 1000

The above gives you a list of contributors who always contribute at least $1000, along with the smallest amount on record for the contributor.

If you want merely a count of these folks, then use this:

SELECT Count(*) AS MyCount
FROM (SELECT [ContactID] FROM [Contributions] GROUP BY [ContactID] HAVING Min([Contribution])>=1000)