CREATE A TABLE FROM A UNION QUERY

[Samora]

Hello everyone

I have a query named QryExport that makes a UNION from 3
tables

My goal is to append the result of this query to a new table.

The table to receive the data is named TExport

The query i have to make the UNION is called Exportar

Although this query works great and gives me the result
that i am expecting , i want that this result could be
placed in that table (TExport) with one single field (125
characters ) in order i can export the result as a Text
file to be send by e-mail.

I am trying to make the SQl code , but it doesn't work and
there are sintaxe errors that i can't fix.

If someone can helps me , i would appreciate very much

Thanks in advance

 

[gls858]

Hello everyone

I have a query named QryExport that makes a UNION from 3
tables

My goal is to append the result of this query to a new table.

The table to receive the data is named TExport

The query i have to make the UNION is called Exportar

Although this query works great and gives me the result
that i am expecting , i want that this result could be
placed in that table (TExport) with one single field (125
characters ) in order i can export the result as a Text
file to be send by e-mail.

I am trying to make the SQl code , but it doesn't work and
there are sintaxe errors that i can't fix.

If someone can helps me , i would appreciate very much

Thanks in advance

Have you tried making your union query a make table query?
Open the query in design view right click the the upper portion
of the query, select query type > make table > give the table a name.

gls858

 

[MacDermott]

Hello, Samora!

When I need to create a new table from a union query, I use a second query
based on the first:
SELECT QryExport.* INTO TExport FROM QryExport

However, there's really no need to create a new table for exporting;
you can export directly from QryExport.

HTH
- Turtle