If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create ... following in the Query window: SELECT last_name, address INTO ...

Use SQL to quickly create a new table from existing records in Access Your email has been sent SQL lets you use one command to quickly create a new table containing a subset of records from a ...