create table?

  • Thread starter Thread starter js
  • Start date Start date
J

js

Hi,

how to create a table and insert data into it base on a select statement in
Access:
SELECT Last_Name,First_Name,Phone_1, count(*) AS Counter
INTO #holdkey

Thanks...
 
Check Access Help on "Make-Table Query" and "SELECT ...
INTO ..." statement.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top