Queries

[Guest]

Dear Sirs,
I have two select queries.
I would like to combine the data from this two, into one query (something
like merging the data) - query 1 + query 2 = query 3
Can someone tell me how to do do that?
Thanks
Klaus

 

[Jason Lepack]

It depends...

We're not there. We can't see what you're doing. Post the SQL of the
two queries as well as information about what the queries do and what
you would like this 3rd query to output and we'll get back to you.

Cheers,
Jason Lepack

 

[Guest]

Use a union query.
Create your new in design view and do not add any tables.
Click on SQL view button on the toolbar
Type
SELECT ALL * FROM [Query 1];
UNION ALL SELECT * FROM [Query 2];

Save your new query 3

 

[Guest]

I get the error message: Syntax error (missing operater) in query expression
'*[query1]'.
Can you tell me what that means?
Thanks
Klaus

Use a union query.
Create your new in design view and do not add any tables.
Click on SQL view button on the toolbar
Type
SELECT ALL * FROM [Query 1];
UNION ALL SELECT * FROM [Query 2];

Save your new query 3

Dear Sirs,
I have two select queries.
I would like to combine the data from this two, into one query (something
like merging the data) - query 1 + query 2 = query 3
Can someone tell me how to do do that?
Thanks
Klaus

 

[Guest]

You need the word FROM and a space and the actual name of your queries
instead of query 1, query 2

* FROM [The name of your query];

I get the error message: Syntax error (missing operater) in query expression
'*[query1]'.
Can you tell me what that means?
Thanks
Klaus

Use a union query.
Create your new in design view and do not add any tables.
Click on SQL view button on the toolbar
Type
SELECT ALL * FROM [Query 1];
UNION ALL SELECT * FROM [Query 2];

Save your new query 3

Dear Sirs,
I have two select queries.
I would like to combine the data from this two, into one query (something
like merging the data) - query 1 + query 2 = query 3
Can someone tell me how to do do that?
Thanks
Klaus