Set a default sort on a table

[Jerry Tovar]

How can I set a default sort order on a table so that wherever I view this
table, the table is always in my prefered sort order?

I have a MS Access 2002 MDB with a customer and invoice table. I related
these tables together, 1-Many, and placed them both in a form. The invoice
table displays in a datasheet below the customer table. I want the invoice
table to always be sorted by InvoiceDate DESC.

How can I do this?

Thanks,

Jerry Tovar

 

[ruralguy via AccessMonster.com]

Always view you table with a query where you can specify an OrderBy clause.
Tables in Access really do not have a dependable order unless you use a query
to view them.