Make Table query question - Autonumber field 3

[Nilo]

Is there a way to create an AutoNumber field from a Make Table query?

 

[PHV]

When the make table query is finished execute the following one:
ALTER TABLE myNewTable ADD COLUMN myID COUNTER(1,1);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Nilo]

Perfect! works like a charm