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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Consecutive numbers in my Qry 2

Status
Not open for further replies.
molly

molly

Technical User
Jul 17, 2000
219
US
My Qry lists the all the sales in descending order. i would like to rank them 1 to whatever. With 1 being the first best revenue record going downwards.
How? Thanks
 
Sort by date Sort by votes
Is there a simple method without a Module function?
In other words, something simple inside the qry only?
Just wondering.

thank
Molly
 
Upvote 0 Downvote
I don't know. What is the problem with the module function? They're a snap.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
693
renigar
renigar
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
735
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
584
Trob70
Trob70
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
393
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top