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.