Skip to content

Ordering Records as Entered

Making records appear in the order they were entered.

Q: Frank Payne writes:  “I would like the data in a particular table to appear in exactly the order in which I enter the records.  I do not want it sorted in either Ascending or Descending order.  I have deleted the Order By property, but it still sorts the table in Ascending order.  Can you help please?  Is there a way to do this? “

A:  In the table itself, the records should be in the order they were entered.  If the problem is with display of records on a form or report, add an AutoNumber field to the table and make it the key field (even if you don’t need it).  That will make the default sort by the ID, which means that the records will be in the order they were entered.

About this author