Around 5:00 you speak of the Union Query button not working or not sure. I have also found it is broken and did the same thing as you have shown - SQL only. The reason for my stating this is to also state that it is broken (or behaves the same) in both Access 2007 and 2010 as well.
Reply from Alex Hedley:
Thanks for confirming it in 2007/2010
Keith Stanton
@Reply 5 years ago
Using Office 365, clicking the union button does the same thing still.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 16.
