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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate two fields into one in same table 3
Insert row, table to table - where append goes to correct record 2
Now asking for missing semicolon ???????? - Guidance please 4
Unmatched Records issue 5
combining fields in query 2
How to Populate Data from a table to another 0
rolodex 2
HELP: Populate corresponding userform text fields from access data 1

Back
Top