0

I have this code in access that runs, but it is not giving me a unique row number. I think it's because the data set contains so many duplicate values. Is there a way to write this code so that i can get a unique row number?

Code:

SELECT A.*,

(SELECT COUNT(*) FROM QUIKVALF WHERE A.MPOLICY>=MPOLICY) AS RowNum

FROM [QUIKVALF] AS A ORDER BY A.MPOLICY ;

Thank you

Dgbow
  • 85
  • 5
  • This is a very common topic. Review http://allenbrowne.com/ranking.html. Edit question to show sample data and desired output as text tables. – June7 Jul 16 '21 at 18:22

0 Answers0