How to retrieve data from a query into a table

[bob.dodman]

I am having trouble retrieving data from a query and creating a table from the data.
type or paste code here

[Wanderer]

I assume you wish to populate a table inside Base with results from a query.

Query may be:

SELECT Name, Adr FROM Members

and you with to write this in the new Table Mail then use

INSERT INTO Mail
SELECT Name, Adr FROM Members

and use the SQL-Window (Menu Tools->SQL) for this. As this is a command it will not run as a query.
.
If you need the data “outside” Base, drag the Name if the query to a Table in Calc. The data will appear in the Calc-Sheet.