make table query

[krberube]

This is the first time i try this and just want to double check this.
Running a make table query DOES NOT change the data in the original table, correct???
I ask this because, when i run it, a message pops up stating " you are about to run a make table query that will modify data in your table, proceed, yes/no"

Thanks

 

[FoFa]

As long as you are creating a NEW table, it should not.
If you specify an existing table, it will delete than recreate the table (causing loss of all data in it before).

 

[RV]

If you're not 100% certain of the final result of running a make table, an append, an update or a delete query, then first make a copy of your source table.
Next run your query and review the results.
If unexpected, just delete your original table and rename your copy to the name of your original table.

RV