How to Sort by Record Number???

[Jessi]

Hello. I'm almost ashamed to ask this question, but how do you
remove sort orders that were previously applied to the database?

I want to return to the original order that it was entered into the
database (by record number), and I can't figure out how to do it...
I see where you can choose a field and select the Ascending or
Descending button, but how do you just sort by record number?

Thanks for any help!
Jessi

 

[Jeff Boyce]

Jessi

Where? As in "where do you want this sort to take place?"

In a query? In the table (tsk, tsk, you shouldn't be using the table
directly for data entry, etc. <g>)? In a report?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

If you are talking about a table, then use the Remove Filter and Sort
under ?Records? in the menu.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[John W. Vinson]

Hello. I'm almost ashamed to ask this question, but how do you
remove sort orders that were previously applied to the database?

I want to return to the original order that it was entered into the
database (by record number), and I can't figure out how to do it...
I see where you can choose a field and select the Ascending or
Descending button, but how do you just sort by record number?

Since Access tables don't HAVE "record numbers", the question as phrased can
only be answered "you can't". Do you mean an Autonumber value as the sort key?

Note that a Table *HAS* no order. It's an unordered heap of data. You can
choose to display it in a particular order, but it's really better to do
explicitly what Access does in the background when you do so: create a Query
based on the table, and specify the sort order for that query. You can use
this query in just about any context where you would use the table.

John W. Vinson [MVP]