Create Autonumber field in Query
In Jet, you can't, natively, in one step; with MS SQL Server, use IDENTITY:
SELECT IDENTITY (int, 1, 1) AS Rank, discount
ORDER BY discount ASC
With Jet, create the table first, with an autonumber, then, in a second step, append data to it,
without specifying anything to the autonumber field.
Hoping it may help,
Vanderghast, Access MVP
> I want to create a table by using make-table query. But the autonumber field
> needs to be added to the table. How can we add the autonumber field to the
> table by using a make-table query?
> Your help is appreciated.