Append multiple queries into an empty table via code

  • Thread starter Thread starter Durango
  • Start date Start date
D

Durango

I am fairly new to access and have been struggling on how to do the
follow and would appreciate any help.

I have multiple queries called
"Qry_Route01","Qry_Route02","Qry_Route03", and so on. Each query has
two fields [cabletag] (Same in all Queries) and [Route01] or [Route02]
or [Route03] and so on. The [route01] is in query "Qry_Route01" and
[route02] is in query "Qry_Route02" and so on.

I have a empty table called "Tbl_Temp_Route" which contains the fields
[Cabletag] and [Route]. What I would like to do via programming code is
to have all the [Cabletag] and [Routes] appended to the table. I don't
know if I should do it via SQL or what the best and easiest solution
is. I am still trying to understand how to program via SQl, but it
doesn't look like the help with the ACCESS is that great.

Can any one help?
 

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

Sorting Report 2
Counting Runners 4
Insert Into a SQL table via Access 2007 8
Append Query 3
Append Query 1
Append only Null records in table 2
Access Dcount (multiple criteria) 3
Problem With Autonumber & Append Query 2

Back
Top