Add Auto-Number Field using a query

[bbacksoon]

Help me, I am looking for a way to add an Auto-Number field to either a new or exsisting table using a query. The only way I can do this now is to manualy insert a new field and set it to Auto-Number. I would like to take this manual step out of my process.

Thanks,

Robert

 

[smoker1]

Robert,

Access help topic "change the starting value of an autonumber field" tells you how to accomplish this with a query.

Hope that helps.

Angela