update filed in query access with duplicate filed : i have table like this
UserName        tel            Active
-----------------------------------------------
michael       12345678           t
michael       23441606           t
nabil         32564189           t
nabil        54655526            t
mic        5 1233333             t
mic         12121212             t
mic         12131313              t


i need to make update to field Active to be like this
UserName        tel            Active
-----------------------------------------------
michael       12345678           t1
michael       23441606           t2
nabil         32564189           t1
nabil        54655526            t2
mic        5 1233333             t1
mic         12121212             t2
mic         12131313             t3

