Moving records

[Aardvark]

Hi folks,

is it possible to change the order of records in datasheet view without
using sort? The final version the records do not show any logical sequence
in any of the fields.

Thanks,

Danny

 

[Van T. Dinh]

Records are stored unordered. Use the Sort in the datasheet view of the
Table or if you prefer, use a Query which includes an ORDER BY clause.

 

[Aardvark]

Thanks, I have unordered records.....for example smith, williams, brown. I
would like to change the record order without applying a logical sequence to
it (as you get from a sort)

So in this example I might want to change it to Smith, brown, williams.

Danny

 

[GVaught]

No can do. Records are ordered as entered (assuming no primary key) or by
primary key. You can only change the ordering using sorting.