Forum Discussion
Record order shuffles spontaneously!
I'm using a membership database. The main contacts form is used to enter data. The query that populates this form is sorted on ID (prime key). Initially the forms appear in ID order and I've opened a...
Tables in relational database applications--like Access--have no inherent sort order. If you must have records presented in a specific order, then you must use an ORDER BY clause in a query to impose that sort order. You can not, in other words, count on your query to consistently sort on ID unless you add that ORDER BY clause to the query: ORDER BY ID
- Thanks George. I sent this to my colleague who wrote the database. I don't know exactly what he did but he wrote me a new query which will do the job and won't go wrong. Thanks for your help.
- Congratulations on solving the problem.
Continued success with the project.
