Re: How are these sorted

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Of course - apologies -
didn't realise that if you right click on a column and change the data
order, Access retains this information and order next time dataview is
opened.


"Chaim" <Chaim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:081B9664-9999-4BAF-80D2-68BD55ABA7DA@xxxxxxxxxxxxxxxx
> Steve,
>
> Care to enlighten? Having raised and resolved the question, maybe others
> of
> us would be interested in what youv'e learned.
> --
> Chaim
>
>
> "Steve J" wrote:
>
>> Its Ok, I see what is happening now thanks all the same
>>
>> S
>> "Steve J" <somone@xxxxxxxxxxxxx> wrote in message
>> news:uL5VXQEaFHA.1940@xxxxxxxxxxxxxxxxxxxxxxx
>> > Hi Jon
>> >
>> > yes I realise that, but what really puzzles me about this instance is
>> > that
>> > I can add records to the table with different surnames, and when I open
>> > the query, they are sorted by surname. I have opened and closed the
>> > query
>> > about 20 times and each time they are sorted, so I am thinking there
>> > has
>> > to be something I am missing?
>> >
>> > S
>> >
>> >
>> > "JohnFol" <OutlookExpress@xxxxxxxxxxxxxxxx> wrote in message
>> > news:6GYne.432$jS3.344@xxxxxxxxxxxxxxxxxxxxxxx
>> >> You cannot guarantee which order they will be returned in, unless you
>> >> specify an Order By clause within a query.
>> >>
>> >> Normally Access will default to retrieve records in a query based on
>> >> the
>> >> PK of the table.
>> >>
>> >> Either way, best to specify what you want in the Order By
>> >>
>> >>
>> >> "Steve J" <somone@xxxxxxxxxxxxx> wrote in message
>> >> news:Ogc8wxDaFHA.3132@xxxxxxxxxxxxxxxxxxxxxxx
>> >>> Hi
>> >>> I have atable in which drecords have been entered at random However
>> >>> when i open a query that is based on that table, the records are
>> >>> being
>> >>> displayed sorted by the surname field, but if I look in Design view,
>> >>> the
>> >>> surname field (in fact none of the fields) does not have any sort by
>> >>> attributed set?
>> >>>
>> >>> How is this please?
>> >>> A
>> >>>
>> >>
>> >>
>> >
>> >
>>
>>
>>


.

Relevant Pages

  • Re: Yaris diesel head gasket failure
    ... > Apologies from a newbie to this group. ... However, my query is this: ... > warranty, and I would have expected them to do the job for free if it was ... Once the vehicle is out of warranty, ...
    (alt.autos.toyota)
  • Yaris diesel head gasket failure
    ... Apologies from a newbie to this group. ... I realise my query may not be relevant to this group, ... The head gasket recently failed on my Yaris diesel. ... Is this a known fault on these engines? ...
    (alt.autos.toyota)
  • Re: How to query for duplicates using two fields?
    ... "Brown" on Newcastle Stone 109 as separate names. ... The query says there ... are 53 surnames - which is accurate in terms of records - but if I ...   John Spencer ...
    (microsoft.public.access.queries)
  • Re: Automatic field filling
    ... The general principle, in the example you gave, is that the second table ... Apologies ... name by reference to the first table, so it is redundant to store this ... last name fields form the first table directly into the query, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: update query - replace x number of characters in ()
    ... "Lewis Brunton" wrote: ... > I have a table worth of data with Surnames in it, ... > But I would much rather have a query that removes any ending with brackets. ... Set rst = CurrentDb.OpenRecordset ...
    (microsoft.public.access.queries)