sorting records

[Tim]

Is there any way for me to sort a table in the order that
the records were created even though the table has no
autonumber or primary key (it's an old table that was
designed very poorly, unfortunately)?

thanks for any help,
tim

 

[Steve Schapel]

Tim,

I guess the answer is No, as there is no way for anyone to identify
the order in which they were created.

- Steve Schapel, Microsoft Access MVP

 

[Lynn Trapp]

Tim,
Let me add one thing to what Steve said. Typically this kind of thing is
handled by a Creation_Date field that stores the current date/time that the
record was initially created. In the absence of such a field or a primary
key, I'm afraid Steve is absolutely right.