Access-Please Help!

[Guest]

Whenever I open my table, the data is all automatically sorted by the ZIP
code of my customers. However, I am trying to get it to sort by Last Name.
Where can I change where it normally sorts by? I've tried sort
ascending/descending, but it resets every time I re-open the table. Help?

 

[Guest]

Usually a table will sort the records by the key of the table, unless there
is a sort applied to the table

Open the Table in design view
Open the table properties (press Alt+Enter)
Check the OrderBy Property

 

[Van T. Dinh]

Open the Table in DesignViewView then open the Properties window of the
Table. There should be a "Order By" row in the Properties window where you
can enter the Field name for Last Name. Close and save the Table.

When you open the Table in DatasheetView, the Records will be ordered by
[Last Name].

 

[John Vinson]

On Mon, 10 Oct 2005 14:29:06 -0700, "Ozarks Affordable" <Ozarks

Whenever I open my table, the data is all automatically sorted by the ZIP
code of my customers. However, I am trying to get it to sort by Last Name.
Where can I change where it normally sorts by? I've tried sort
ascending/descending, but it resets every time I re-open the table. Help?

Ofer and Van have given you correct answers; but I'd suggest that you
consider NOT using table datasheets for much of anything other than
debugging. You can base a Form on your table, or - better - on a Query
sorting the data in your table. Forms have a lot more capability than
tables, including being able to quickly search for a record, etc.

John W. Vinson[MVP]