Autonumber in excel for mac11/6/2023 Click Queries on the left pane, and then double-click Create query in Design view on right pane.Delete the AutoNumber field from the main table, and note the AutoNumber field name. To do this in Access 2003 or in an earlier version, follow these steps: You can reset an AutoNumber field value by using a Make-Table query to create a new table that has the same data and then adding a new AutoNumber field. Method 1: Move the data to a new table using a Make-Table query If your table has no relationships to other tables, use either Method 1 or Method 2 to reset an AutoNumber field value. Reset an AutoNumber field in a single table You must back up your database before you perform the steps that follow.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |