joining tables

[ashley1]

This is quite simple but im finding it quite hard to cum up with a solution
i have 2 select queries from one table which give me different results, i would like the results to come togther and add to another table
I have also done this as 2 seperate append queries which works fine but would be better if we could do in one whole!!!
the tables have the same format and same fields
how can i go about doing this???
thanks

 

[Brianwarnock]

It sounds as tho the 2 queries are identical except for the criteria, why not just OR the criteria in one query

Brian