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

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?
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top