Saved and Closed a Data Table; When Reopen Data is Out of Order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I entered data on an Access table and closed it to save. When I reopened it,
the data was out of the order that it was in when I saved it. Why? How do I
prevent this?
 
This is an important question.

Think of a table as a big bucket where you throw data in. It really has no
order, and there is no guarantee it will ever come out in the order you put
it in.

If you want it ordered, you must provide a way to do this. A common approach
is to add an AutoNumber field, and make it the primary key. Since the
autonumber increments as you use it, and Access displays records in primary
key order by default, this probably does what you want.

The central idea is that you must provide some way to sort the data the way
you want it. You can then use a query to sort by the field(s) you want.
 
Back
Top