Hi,<br><br>I am working on a Top 20 customer list. The issue is that I have to compare 1999 to 2000 (keeping 2000 as a benchmark) and therefore rank my data in a query (to also get the top 20). So the idea is Cust rank 2000 against Cust rank 1999.<br>Right now we have Previous and Current Yr make table queries, which we run and then manually create a new field in the table and have it as an Autonumber.<br>Can we automate this process ? <br><br>Thanks for your help !!!<br><br>n.<br> <br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating a Top 20 Customer list.
- Thread starter 93411141
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question