Combinine data from two separate queries

[Dbless]

I have two queries that I want to combine all the data from one into the other. Is this possible?

The reason for two queries is a one to many relationship with totals.

 

[JoJ]

If both queries have the same field structure, you can use a UNION query to combine both recordsets.

In design mode, choose SQL from the view menu. Then type an SQL string that looks like this:

SELECT * FROM Query1
UNION SELECT * FROM Query2;