I have an issue with a slow running Query and I believe because it is a Union Query.
My question is I have 8 tables that are being "unioned" in this query. The user types in data for the criteria in text boxes on a form and hits a button to run the query. With this being said, I would like to build 8 separate queries and then add a listbox on my form that chooses which query I want the rest of the text boxes to generate criteria for that chosen query. Gosh that was complicated to get out.
Can someone help me with this if it can be done?