[AccessD] Access 2007 - How to unfilter / unsort

LOL, right you are but this is ME doing this stuff.  And I absolutely allow ME to see the tables 
directly.  ;)

I am in development.  I am sorting a table to see newly created records etc.

I didn't mean to sound snippy.

John W. Colby

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

On 5/22/2013 8:48 AM, Heenan, Lambert wrote:
> ' Not true and never has been.  You can go directly into a table.." True, never has been a good idea.
>
> Of course I *know* that you never let your users get to see a table directly, that just bad practice/insanely dangerous to  data. And I know, as the experienced developer you are that you are fully aware of that. But developers make mistakes too. So I just try to stay away from displaying tables directly. I see you got your solution to the non-problem though. :-)
>
> 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 4:57 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
>