add increment numbers

[Guest]

Dear All,

please help. I want the first coloumn of my query to be auto increment
numbers.
How do I do that?

Thanks,

 

[Michel Walsh]

Hi,


The most generic solution with Jet, is to append the data into a brand new
table which has a autonumber field.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

One method would be Ranking. Search on that topic.