Count/DCount Solution

  • Thread starter Thread starter SGP
  • Start date Start date
S

SGP

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))
 
Back
Top