automationamateur
Board Regular
- Joined
- Jan 3, 2011
- Messages
- 166
I have a simple query that results in two fields: 1. Client#, and 2. Margin$. Query1 (lets call it) is sorted Descending on Margin$. I simply want to add sequential #'s based on Margin$ (see below, 'rank' column is what I'm after. I am shocked by how difficult this is. I have tried multiple suggestions from AllenBrowne, datapigtechnologies, microsoft, other blogs, etc. My query has ~150 records (each record of a unique clientid and associated margin $'s). The queries I've tried don't fail but I've waited 10+ minutes waiting for it to complete and it never does. Are ranking queries, dsums, dlookups, etc all really this slow given I only have 150 records to rank? I used the exact query at the link below. Am I missing something really obvious? Thanks for the help guys!
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody> </tbody> | ||||||||||||||||||||
Code:
Code:
| ||||||||||||||||||||
<colgroup><col><col><col></colgroup><tbody>
</tbody>