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.