Forum Discussion
Office 365 - Access
I have a very large Access file consisting of 30 fields and some 80 entries in each field. Whenever I add a new entry and save it the program changes the order of the fields. This means that when I r...
Actually, even this type of saved property is not really appropriate for tables. Access alone offers this as a "feature" for newer, less experienced users.
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.
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.