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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Ranking Records
PHV, I have not actually checked to see which one is faster. I tried the first one and it worked PERFECTLY. I will however try the other and see which one runs quicker. I do appreciate the help greatly....- MJSteve
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Ranking Records
PHV This works perfect...Even across 2 Million + records, its fairly efficient for my purposes. Thank you for your help- MJSteve
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Ranking Records
hi SkipVought The example I displayed is actually in a table named - tbl_normalised. What I would like to do is programmatically update a rank field in the to what I show in the bottom example of what i need the resultant table to look like. Regards Steve- MJSteve
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Ranking Records
Hello all, I have a table with some 2 millions records. it is as such npanxxxxxx Carrier IXC 201007???? ATT 0.0069 201007???? ITL 0.0017 201007???? LVL 0.0049 201032???? ATT 0.01717 201032???? ITL 0.0092 201032???? LVL 0.00758 201040???? ATT 0.01126 201040???? ITL 0.0039 201040???? LVL 0.0018...- MJSteve
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
