Penrodcigar
Technical User
How can I write a make a table query that will add an autonumbered field to the new table ?
DoCmd.RunSQL "SELECT Inventory.Face, Inventory.Price, Inventory.Quantity INTO Autonumber FROM Inventory WHERE (((Inventory.Face)="xxx"))"
This DoCmd will produce a table called Autonumber with records based on criteria "XXX", but how do I get it to add a field to the table with a unique autonumber for each record ie 1,2,3,4 etc?
DoCmd.RunSQL "SELECT Inventory.Face, Inventory.Price, Inventory.Quantity INTO Autonumber FROM Inventory WHERE (((Inventory.Face)="xxx"))"
This DoCmd will produce a table called Autonumber with records based on criteria "XXX", but how do I get it to add a field to the table with a unique autonumber for each record ie 1,2,3,4 etc?