A ashley25 Registered User. Local time Today, 21:27 Joined Feb 17, 2013 Messages 46 Oct 14, 2013 #1 How can you determine the name of a table that has/is going to be created by a make-table?
J JHB Have been here a while Local time Today, 22:27 Joined Jun 17, 2012 Messages 7,732 Oct 14, 2013 #2 When you run a make table query, you have to give the table a name. The syntax of a make table query is shown below: Code: SELECT [OneField], [AnOtherField], .... INTO [TheNewTableName] FROM [Atable];
When you run a make table query, you have to give the table a name. The syntax of a make table query is shown below: Code: SELECT [OneField], [AnOtherField], .... INTO [TheNewTableName] FROM [Atable];
R redalert Registered User. Local time Today, 21:27 Joined Oct 7, 2013 Messages 62 Oct 14, 2013 #3 If you look at the 'Destination Table' property in the properties of the query then this will state the table that will be created. Open the query in design mode, right-click in the grey area above the grid and select properties.
If you look at the 'Destination Table' property in the properties of the query then this will state the table that will be created. Open the query in design mode, right-click in the grey area above the grid and select properties.
