Add 2 queries

[rscosta]

Hi

I've build two diferente queries with the same fields (they have diferent
records). How can I add the 2 queries in just one?

Thanks

Ricardo

 

[KARL DEWEY]

Use a union query.
Or why not just use one and put your criteria in separate rows in the
design view. This ORs the criteria.

 

[Marshall Barton]

I've build two diferente queries with the same fields (they have diferent
records). How can I add the 2 queries in just one?

Try using a UNION query to do it.

SELECT ...
UNION ALL
SELECT ...

That can not be done in the query design grid so you'll have
to use SQL view to create the combined query.

If that's not what you mean by "add the 2 queries in just
one", post back with more details about what the final
results you are trying to achieve.