reordering records

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

Guest

I was wondering if it was possible to change the order of records in
datasheet view? Say I want to insert 5 records in the middle of a record
set. If I try to add a record they will go to the bottom of the table (unless
of course I set up a field for order, which I don't want to do).
 
No. You must set up a field to define the order you want.

In relational database theory, tables are unordered. They are just buckets
to hold the records for you, and there is no order, i.e. if you ask for the
records and don't specify an order, the order is undefined, and the database
could even offer them differently when you run the same process twice.

In practice, Access shows the records in primary key order if you don't
specify any other order. But you cannot have an ordered set of records
unless you have a way of specifying the order.
 
Back
Top