Table sorting question

  • Thread starter Thread starter jamesu27
  • Start date Start date
J

jamesu27

I have an Access table where there are only 2 columns, a text column and
number column that is not sorted in anyway. I have always been able to add
data to the bottom of the table and it stays at the bottom. But recently,
every time I add new data, it gets sorted to the top and only the new data
gets moved. Why is that and is there a way to prevent it?

Thanks
 
Tables don't have an order: the data is stored however Access sees fit to
store it.

If the order of records is important, create a query with an appropriate
ORDER BY clause in it, and use the query wherever you would otherwise have
used the table. Note that this may necessitate adding a new field to your
table, CreateDtm, with its default value set to Now() so that you have a
field on which you can sort chronologically.
 
That's the way databases work. Tables just hold data and in no certain order.
Sometimes they seem to do so, but it's an illusion.

To sort records you can use queries, forms, and reports. Pick which field
that you wish to sort on, and run it.

Now if you need the records to display in a particular order but it really
isn't anything that can be sorted on in your two columns, you'll need to
create a third field and manually populated it with data so that the query,
form, or report displays it as you wish. I recommend using a Number field of
the Double type. That way you can squeeze in a 1.5 between 1 and 2 if it
becomes necessary.
 
Back
Top