Add new query results to old one.

[omair1051992]

I have a working query that filters out contacts from a table according to the values entered in a form. The query shows up results in a separate table and if I have to run the query again, with different values and expecting a different result, I have to close the previous query and run it again.



Is there a way that the new results can be added to the previous results? For example, if I first filter out contacts A and B and then C and D, the query would add C and D to A and B and show all of them together rather than close the previous results and show just the two new ones.

Thanks!

[JoeM]

If you want to combine the results of numerous queries/filters in one, I would either recommend using multiple queries and using a Union Query to combine the results of all those queries into a single query, or write the results of each query to a temporary table and then open that.