Create a table like a query?

  • Thread starter Nigel Molesworth
  • Start date
N

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?
 
E

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
 
N

Nigel Molesworth

Look at Access HELP for "Make Table" queries.
Click to expand...

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