What determines the order in which records are viewed

G

Garry

Hi all

What determines the order in which records are viewed in a table

If I import data or create a new table from a query

regards, Garry
 
S

scubadiver

The only thing that can do it is a date or time stamp. That is if you use

=date()

or

=now()

as the default value.

Or you use an autonumber.

Otherwise there is no order.
 
A

Allen Browne

If the table has a primary key, records are sorted on this field.

If the table has something in its Order By property, that affects the
sorting. (Typically you set this by right-clicking a field, or clicking A-Z
on the toolbar.)

If neither apply, the order of records is undefined. They may appear in the
order in which they were input, but you can't rely on this (e.g. it may
change after a compact/repair.)

If you want to maintain the order of the records from the query, create the
table with all the fields matching the query, with an AutoNumber field set
as primary key. Then turn the query into an Append query (Append on Query
menu, in query design.)
 
P

Pieter Wijnen

The order of import. But it is of no significance, you should always rely on
queries to sort your data

Pieter
 
Top