Question: how to transfer data from query to table access?
Answer: Open the database that contains the records that you want to copy.
On the Create tab, in the Queries group, click Query Design. ... 
Double-click the tables or queries that contain the records that you want to copy, and then click Close.