Good Morning Everyone. I have a simple access question that I have been struggling with for years.
I have a table of data that has roughly 300,000 customer ids and sales in it. I want to rank that table from 1 to 300,000 in descending order. I can’t find a good way to do this is in access. Does anyone know how to do this?
Also, if there is a tie value I’d like to score it the same. For instance if id there are two customers at position 3 that each have $100 in sales the rank could go 1,2,3,3,5 etc.
For simplicity purposes, the table has 2 fields in it Cust Id and Sales.