Self Incrementing row counter in a Query

[Ken Higgins]

Anybody know how to include a column which just increments by 1 for each row
that the query generates?

Thanks!

 

[Michel Walsh]

Hi,



append the data to a table with an autonumber field,


or rank the data on the primary key.



Hoping it may help,
Vanderghast, Access MVP

 

[mf_sina]

thanks Vanderghast
it was my question too
your answer worked fine