D
Dale Fye
You need a Union query. The down side of this is that you
cannot write a union query in the query grid, you have to
write it in SQL.
Step:
1. Open the second query, select SQL View, and copy the
SQL.
2. Close that query and open your first query
3. Delete the semicolon at the end of the first query
4. Type UNION on the line below the end of the first query
5. paste the SQL you copied from the second query on the
line following "Union"
6. Make sure that the fields match up so that they are in
the same sequence in both queries.
If this doesn't work, copy the new SQL and paste it in a
response to this message.
HTH
Dale
people are included in both those queries.
cannot write a union query in the query grid, you have to
write it in SQL.
Step:
1. Open the second query, select SQL View, and copy the
SQL.
2. Close that query and open your first query
3. Delete the semicolon at the end of the first query
4. Type UNION on the line below the end of the first query
5. paste the SQL you copied from the second query on the
line following "Union"
6. Make sure that the fields match up so that they are in
the same sequence in both queries.
If this doesn't work, copy the new SQL and paste it in a
response to this message.
HTH
Dale
like to merge them into one query but some of the same
people are included in both those queries.