[AccessD] Access 2007 - How to unfilter / unsort

" the sort order of a table is undefined"

True

So if you want to see it in a particular order you have to write a query.

Not true and never has been.  You can go directly into a table, click on the field header and 
execute a sort which will sort ascending / descending on that column.  This is just Access "helpful 
stuff" that has always been around.

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 5/21/2013 12:13 PM, Heenan, Lambert wrote:
> " the sort order of a table is undefined " So if you want to see it in a particular order you have to write a query.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
> Sent: Tuesday, May 21, 2013 11:48 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access 2007 - How to unfilter / unsort
>
> When I open a table I can set a sort order on a column, but when I click the little arrow, there is no clear filter.  Well... it is n't a filter it is a sort.  But there is no "clear sort" either.  So...
>
> When I sort a table (or query) on a column in the data grid, how do I clear the sort, short of closing the table without a save.
>
> --
> John W. Colby
>
> Reality is what refuses to go away
> when you do not believe in it
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>