How do I do in the table

Hi:

How can I make table "Do not sort automatically?

Because I copy the data from one table to another table, the order I already set that, after I copied it, open the table, the table automatically change the order(sort) itself.

So, where do I make the setting "Do not do automatically sort"?

Please let me know, thanks.

Thanks.

As I understand your question, you copy data from one table to another, but the sort order changes in the process.

MS Access does not store the data in the order that you enter it, It can appear in any order that MS Access sees fit. However if you want the data to appear in the order that you entered it, you can add an incrementing auto number field to preserve this order for you.