Is anyone aware of a way to add an AutoNumber field to a Make Table query in design view in MSAccess.
I am trying to create a new field so that it starts at 1 and goes to number of records each time the query is run.
Thanks,
Warren
[This message has been edited by wperzel (edited 03-12-2002).]
I am trying to create a new field so that it starts at 1 and goes to number of records each time the query is run.
Thanks,
Warren
[This message has been edited by wperzel (edited 03-12-2002).]