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).]

If a field from one of the source tables is an AutoNumber, the corresponding field in the resulting table will become an AutoNumber field too. The autonumbering won't work while the make-table is run (you will get whatever values are in the source table) but it will work OK after that.

Simon.

Problem solved programatically.

Thanks

Warren