Microsoft Access

You either need to use a MakeTable query (to create a new table), or an Append query if you want to add to a table that already exists.

I tried the update query and it didn't work.  What did I do wrong?  I updated my document to show the screen prints of the queries I did.
Compliance-Tables.docx

I figured it out.  I had to make some changes to the update query.  It now works.

Thanks for your help IrogSinta.

Looking at your screenshots, it looks like you didn't use my query as I gave it to you. It would have worked if you had inserted it in the SQL view of your query design.