Access-Please Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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].
 
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?
Click to expand...

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]
 
Back
Top