Create a table like a query?

[Nigel Molesworth]

In an Access 2007 database I want to create a table whose data it
taken from a subset of another table, where a certain property is
true. A bit like a query or report with the following syntax.

SELECT Sales.ID, Sales.Quantity, Sales.Address, Sales.Label
FROM Sales
WHERE (((Sales.Label)=Yes))
ORDER BY Sales.ID;

The reason it must be a table is because the program which will use
this data will only allow me to access the tables.

Is this possible?

 

[Ed Robichaud]

Look at Access HELP for "Make Table" queries. Make a copy of your existing
query, open it in design-grid view, select (from the top menu) "Query-Make
Table", designate a location and name for your new table, run.
-Ed

 

[Douglas J. Steele]

You sure you can't get at queries? From the outside, queries and tables
usually look identical to most applications.

 

[Nigel Molesworth]

Look at Access HELP for "Make Table" queries.

Thanks for that, but it seems I have to run the query to update the
table, is this the only way?