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

 

[RobFMS]

Create a field that contains a date/time stamp. Make sure this field is not
shown to the user. You may want to specify (in the table) the default value
of: Now()

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Tim]

To clarify, I want to know the order in which existing
records were created. The date/time stamp field would
only help for future records, as far as I can tell...

Tim

 

[Cheryl Fischer]

Hi Tim,

The best you can do, I think, is to open the table in Design View and delete
all the indexes. The table should then be in physical order.