Ranking Duplicates

[guesswhat91]

I am trying to rank duplicate Please see table below. Any help will be much appreciated. I am using Access 2007 and also have basic knowledge of writing SQL queries. Thanks in advance.

UID	Dup Ranking
2C1017383792014	1
2C1017383792014	2
2C1017833792014	1
2C1017833792014	2
2C1029463792014	1
2C1029463792014	2
2C1029463792014	3

[orange]

What exactly makes a duplicate? What are you ranking -- what criteria are involved? Please provide a description in simple English of what the subject matter is and what you are trying to do. Seems you have multiple pieces making up a UID--can you tell us more?

[June7]

Is there a unique ID field? An autonumber field will serve.

Review http://allenbrowne.com/ranking.html

Also try:

SELECT UID, DCount("*","table","UID='" & [UID] & "' AND ID<" & [ID])+1 AS GroupSeq FROM table;