Expression for Sequential Numbering in An Access Query

I am trying to figure out the expression in a an query. I have numberous duplicate records and I need to sequetially number them starting with 1. Example, 00070545 Needs Approval 1 and 00070545 Needs Approval 2, would be the result fo the first two entries.

CMIR LOAD 2 is the table
CMIR 2 is the field in the table that I am referencing

I get an error after I enter the below code of: Sntax error (missing operator) in query expression '[CMIR LOAD 2]![CMIR 2] <= 51796 Needs Approval.'

Expr1: DCount("[CMIR LOAD 2]![CMIR 2]","CMIR LOAD 2","[CMIR LOAD 2]![CMIR 2] <= " & [CMIR LOAD 2]![CMIR 2])

I am so close...can anyone help?