Queries

A

Amateur

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
 
J

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
 
D

Dennis

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
 
A

Amateur

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

Dennis said:
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

Amateur said:
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
 
D

Dennis

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];

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

Dennis said:
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

Amateur said:
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
 

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

Top