Count/DCount Solution

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
 
S

Steve Schapel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DCount works for one field but does not work with two fields 12
Count If or DCount -SLOW!! 3
copy multiple records based on criteria or total amount 22
tricky question 4
DCount Rookie Question 2
Use a report to count the # records >0 in Access 2003 2
COUNTIF? DCOUNT? 9
LOOOOONG formula, with drop down selection 1

Top