Rank Query

[cbritt927]

Hello:

I can't seem to figure out how to rank my agents. I have a make-table query that creates a simple table that looks like this: (2 columns)




Agent Name Ultimate Agent Score
Sally 325.2
John 328.5
Sarah 258.7
Tom 321.1
92 More

I want to add a 3rd column to the right called "Rank"
1
2
3
etc


I've been googling all night use DCOUNT but I cannot get it!
I'm using access 2013 and prefer design view over SQL view.


Please help!!!!!!!

Thanks so much.

[cbritt927]

I GOT IT!!!! Nevermind!

Thanks all

Clint

[ssanfu]

Care to share your solution?

And to mark this solved??