[AccessD] Access 2007 - How to unfilter / unsort

Heenan, Lambert Lambert.Heenan at aig.com
Tue May 21 11:13:03 CDT 2013


" 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



More information about the AccessD mailing list