On the Design tab, click Make Table in the Query Type group.Double-click the required fields in the table view of the main table to select the fields.In the Show Table dialog box, select the main table.Click the Create tab, and then click Query Design in the Other group.Make note of the AutoNumber field name.To do this in Microsoft Office Access 2007, follow these steps:ĭelete the AutoNumber field from the main table. I think the only ways to do this is outlined in this article. Since these are typically used to import RAW data from a general file format (TXT, RTF, CSV, XML, etc.), the data contained does not persist past the processing lifecycle.These are very similar to Staging Tables but tend to only have two columns: ID and RowValue.Once cleaning operations have been performed and the data is no longer needed, these tables are summarily purged of any data contained.The data contained is only there until additional cleaning actions have been performed and stored in the appropriate table(s).these are tables that are never intended to persist the data they temporarily contain.Any Referential Integrity will be summarily destroyed.This will reset the AutoNumber Counter to 1.Define the name of the DDQ in the Query Name field View and Data Mode settings are not relevant and can leave the default values.Create a Macro with the appropriate logic either before this or after.Starting around ms-access-2016, you can execute Data Definition Queries (DDQ) through Macro's Data Definition Query
0 kommentar(er)
