user6037890 user6037890 - 4 months ago 20
SQL Question

How to create a subset of a table using SQL in MS Access

I have understood that I can write the following query to create a subset of a data set and it worked. I want to use the data set from this query to create another table. How do I save this query as a data set in MS Access?

SELECT [24 months Trx raw data].*
FROM [24 months Trx raw data]
WHERE [24 months Trx raw data].ID<=10;

Answer

The following SQL will create a new table, named MyNewTableName, containing the data from the above SQL statement:

SELECT [24 months Trx raw data].* INTO MyNewTableName
FROM [24 months Trx raw data]
WHERE [24 months Trx raw data].ID<=10;
Comments