By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

How to Make Table

P: 11
i want to select data form a table using where clause.
now i want to create a table instatntly and save data for viewing and printing purpose, after printing i delete table.
since field names in new table are going to be same as in source table, can i create new table without mentioning filed names.

my code follows like this

select * from emp(source) where name=' " & kmk & " '

insert * into details(destination)

is it possible ? any other syntax please help me
Dec 8 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,660
Please remember to provide a meaningful Title for any threads started (POSTING GUIDELINES: Please read carefully before posting to a forum). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR
Dec 8 '06 #2

NeoPa
Expert Mod 15k+
P: 31,660
i want to select data form a table using where clause.
now i want to create a table instatntly and save data for viewing and printing purpose, after printing i delete table.
since field names in new table are going to be same as in source table, can i create new table without mentioning filed names.

my code follows like this

select * from emp(source) where name=' " & kmk & " '

insert * into details(destination)

is it possible ? any other syntax please help me
Expand|Select|Wrap|Line Numbers
  1. Dim strSQL As String
  2.  
  3. strSQL = "SELECT * " & _
  4.          "INTO [Details] " & _
  5.          "FROM [Emp] " & _
  6.          "WHERE ([Name]='" & kmk & "')"
  7. DoCmd.RunSQL strSQL
Dec 8 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.