Create separate tables for multiple sets of records from a pass-through query

1. After creating the pass-through query, create a make-table query based on the pass-through query.

   How?

2. In the make-table query, include all fields from the pass-through query by dragging the asterisk (*) to the design grid.

   When you run the make-table query, you get one table for each result. The first table created has the name defined in the query; subsequent tables have that name concatenated with a sequential number starting at 1. For example, if you want four tables created for four result sets and you choose "NewTable" as the new table name, the tables created will be named NewTable, NewTable1, NewTable2, and NewTable3.