Recordset

[mp3909]

Hello,

I have a table in access - its only consists of 4 records.


I opened up this table using a recordset.
I am now debug.printing the contents of this recordset and noticed that it does not follow the same order as my table.
i.e. the first record in my table is showing in the 3rd row of my recordset.

Is this normal?

[isladogs]

Quite possible. As with a query, the records will be in any order you specify and if you don't specify an order, Access will sort by the first field.

Do you really need to use a recordset to 4 records?
A query will almost certainly be faster in practice

[ssanfu]

In addition to what Colin said, Be Aware that a table has no inherent order.
A table is a "bit bucket"; to introduce order (a "sort") to the data, use a query (recordset) with an Sort ("Order By" clause).


My $0.02........

[NTC]

use a timestamp field in the table to establish the order of entry into a table

add a field to the table: tStamp (do not use the name Time which is reserved)

in the field's property set the default value to: =Now()