from1 to nn access query

[luca90]

I just have an ADO connection opned as CON.

I a table MYtable have many many records, similar 3.400

In my table have a filed named NR

I need a query to update into the filed NR from 1 to 3.400... started from the first record.

similar:

1
2
3
4
...
3400

tath is all.
Tks

[Zvoni]

SELECT
    (SELECT COUNT(T1.NR)+1 FROM MyTable As T1 WHERE T1.NR<T2.NR) AS NewNR,
    T2.ID, T2.NR, T2.Description /*Other Fields*/
FROM MyTable AS T2 
ORDER BY T2.NR

Not tested

UPDATE MyTable As MT 
INNER JOIN 
(SELECT
    (SELECT COUNT(T1.NR)+1 FROM MyTable As T1 WHERE T1.NR<T2.NR) AS NewNR,
    T2.ID
FROM MyTable AS T2 
ORDER BY T2.NR) AS CT
ON MT.ID=CT.ID 
SET MT.NR=CT.NewNR