Export data order

[mikemaki]

Does anyone know what would cause records in a table to change their sequence? I have a table that I clear out. Then I append a header record. Then I append the detail records. The table always is populated correctly. But sometimes, when exported to a text file, the header ends up down amongst the detail records. What would cause this?

 

[Moniker]

Tables do not store data in any particular order. You may get the header at the top, in the middle, or at the bottom. To get a particular order, you need to use a query. This will allow for sorts and everything else you want.

 

[mikemaki]

Does this mean even though the header appears at the top of the table when it is opened, it may be stored differently in the database itself? By the way, I appreciate the suggestion of using a query.

 

[boblarson]

Does this mean even though the header appears at the top of the table when it is opened, it may be stored differently in the database itself? By the way, I appreciate the suggestion of using a query.

Yes, that is true. Tables are not stored in any particular order within Access. What APPEARS to be when you look at it, isn't reality.