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?

Never mind I got it figured out.


Durango wrote:
> 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?