Do you just need one record from the recordset that the query returns or do you need the entire recordset to go into your new table? If you need the entire recordset, make this query an Append Query (go to your Toolbar, select Queries, and select Append Query). Select the table you'd like to Append to and then which fields from your recordset should be Appended to which fields in your table (using the Append To field).
If you only want one record Appended to the table, base a separate query off of the first query and figure out a way to limit the criteria so that only this record is returned. Then, change this query to an Append Query and follow the preceding directions.
