In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

Steps to using SQL in Microsoft Access 1. Launch Microsoft Access and open an existing database or create a new one. 2. Click on the Create tab in the ribbon at the top. 3.

Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.

The third form of the CREATE TABLE statement stores the results of any query-expression in a table and does not display the output. It is a convenient way to create temporary tables that are subsets ...