how to make table union query

If you write a union query in Microsoft Access then try to get the program to turn it into a Make Table query or Append query it seems to remove your union SQL text and start again with a blank