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

Copy result of query to new table

P: n/a
Hi all,

my question is maybe so trivial, that I even could not find it in
Google's NG seach, so I annoy you now:

I simply want to copy the result of a SELECT query to another table
which has the same structure.

All I could do until now is showing the result of the query in another
form with the query as data source:

sSQL = "SELECT REC, PVM, AIKA, TAPLAJI, TUOTE, VARASTO FROM VATAP
"
sSQL = sSQL & "WHERE ((PVM Between [Formulare]![abc_1]![IFrom] And
[Formulare]![abc_1]![ITo]));"
' show the data
Me!abc_1_sub.Form.RecordSource = sSQL

But I want to copy the result to another table.

Any help appreciated!

Thanks,
Rhanda
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Change the query to an append query and append to your table.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Rhanda Zak" <gh*****@gmx.net> wrote in message
news:16**************************@posting.google.c om...
Hi all,

my question is maybe so trivial, that I even could not find it in
Google's NG seach, so I annoy you now:

I simply want to copy the result of a SELECT query to another table
which has the same structure.

All I could do until now is showing the result of the query in another
form with the query as data source:

sSQL = "SELECT REC, PVM, AIKA, TAPLAJI, TUOTE, VARASTO FROM VATAP
"
sSQL = sSQL & "WHERE ((PVM Between [Formulare]![abc_1]![IFrom] And
[Formulare]![abc_1]![ITo]));"
' show the data
Me!abc_1_sub.Form.RecordSource = sSQL

But I want to copy the result to another table.

Any help appreciated!

Thanks,
Rhanda

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.