rownum update sql

[marfi95]

Hi all,

I need to scrub some data prior to shipping it off to a vendor for
them to debug their code. I want to update all the rows in the table
with the rownumber as part of the data. I know in Oracle, for
example, I can use rownum.

So, for example, for my name field, I want to use Name1, Name2,
Name3 ....NameXXX.

How do I write an update statement that will update the column to
include the row number in the data ?

Many thanks !
Mark

 

[Guest]

Access does not have a similar value that returns the current row number. An
alternate idea would be to specify the ID of the rows in question. If you
don't have a row ID, then create a new column and make it an Autonumber data
type.