I am trying to count the number of records on a query that are greater than
three different variables. Let's say I have 100,000 accounts with varying
account values and I want to find the number of accounts that are greater
than $10,000, $20,000, and $50,000. I have a db with over 1,000,000 records
so efficiency is key. So far, my efforts have rendered terribly slow results.

Cheers,
SGP

SGP,

Difficult to anwswer without knowing what you have tried so far. And I
can't understand the relationship between the 100,000 and the 1,000,000
you mentioned in your question. But here's the germ of an idea to pursue:
Over10G: Abs(Sum([YourAmount]>10000))

--
Steve Schapel, Microsoft Access MVP

SGP wrote:
> I am trying to count the number of records on a query that are greater than
> three different variables. Let's say I have 100,000 accounts with varying
> account values and I want to find the number of accounts that are greater
> than $10,000, $20,000, and $50,000. I have a db with over 1,000,000 records
> so efficiency is key. So far, my efforts have rendered terribly slow results.
>
> Cheers,
> SGP