Forum Discussion
Office 365 - Access
tfhancockbtinternet an access file or database consists of tables of records and queries, forms and other objects to manage, view and report the records. An entry is normally done through a form connected to a table but it can be done directly on the table. An entry consists of a new record and will consist of entries into various fields for example membername, datebirth, address, phone. If you open a table access lets you sort the records and when closing will ask if you want to save "the changes to its design". If you click yes it will keep the sorting and the next time you open the table you will see this sorting. Let's say you want to sort your "member" table by membername ascending, open the table, click inside the membername field, in the Home tab under Sort and Filter click on Ascending, then save, or if you forget to save Access will ask as I said before.
In reality, if we are right in assuming that we are talking about sort order of records, then the proper way to do that is a query with an ORDER BY clause.
George_Hepworth and open the query instead of the table or use the query as record source for a Form. But we don't know how object "rich" his project is. Judging from the explanation, it seems to be simple.