I've created a UNION query when run by itself opens the result set just fine. However, when executing the query with a DoCmd.OpenQuery statement, the result set opens (wondering why it opens; just because it's a SELECT) and new table is automatically created with a name of "Name AutoCorrect Save Failure"; where the result set is not saved. I was originally trying to do a UNION query with an INSERT INTO, but upon reading that it's best to do in 2 steps. I need the results set saved so that it can be Appended/Inserted into a new table.