If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count/DCount Solution
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 |
#2
|
|||
|
|||
Count/DCount Solution
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 |
Thread Tools | |
Display Modes | |
|
|