Re: Ascending/Descending

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

From: NickH (anonymous_at_discussions.microsoft.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 08:22:56 -0800

Hi Julie

It looks the problem has now resolved itself or perhaps
after my dithering, I have manged to resolve the issue.
Sorry for wasting your time, it was down to the Signal
Field causing problems.

Thanks

Nick
>-----Original Message-----
>Nick
>
>bit confused here - if you put sort ascending on both
fields with sessionid
>to the left of signal field i can't see why it's sorting
so strangley, can
>you print screen (alt + printscreen) on the keyboard the
query grid and
>email it to me.
>
>Cheers
>JulieD
>
>"NickH" <anonymous@discussions.microsoft.com> wrote in
message
>news:d59601c40aa4$79adbcc0$a401280a@phx.gbl...
>> Hi Julie
>>
>> I had a look and the Session ID field is to the left of
>> the Signal Field, in the query grid
>> I have had ago at changing fields within the
table "Index"
>> table put still the same sort of problem exists
>>
>> Nick
>> >-----Original Message-----
>> >Hi Nick
>> >
>> >in your query grid what is the order of the two
fields -
>> access sorts left
>> >to right.
>> >
>> >Cheers
>> >Julie
>> >
>> >"NickH" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:d41d01c40aa1$a0272970$a301280a@phx.gbl...
>> >>
>> >>
>> >>
>> >> Hi Julie
>> >>
>> >>
>> >> Thank you for the quick reponse, yes I did try this.
>> >> But the problem is if I select Ascending on the
Session
>> >> ID, and then select Ascending on the Signals field it
>> >> reverts back as per the example below.
>> >>
>> >> Session ID Freq
>> >>
>> >> 5 0.165
>> >> 4 0.165
>> >> 3 0.165
>> >> 2 0.165
>> >> 9 1.233
>> >> 10 1.233
>> >> 11 1.233
>> >> 12 1.233
>> >> 7 1.233
>> >> 8 1.233
>> >> 5 2.678
>> >> And so on
>> >>
>> >> So selecting the Session ID you obtain the result as
>> shown
>> >> below and Ascending on the Freq Field you obtain the
>> >> result above.
>> >>
>> >> The Session ID is set as "Number" as is the "Signal"
>> Field
>> >>
>> >> Thanks
>> >>
>> >> Nick
>> >>
>> >>
>> >> >-----Original Message-----
>> >> >Hi Nick
>> >> >
>> >> >i'm assuming that you have sort ascending set on
>> Session
>> >> ID in the query
>> >> >grid, if not, click in the sort line and choose
>> >> ascending, then do the same
>> >> >for the Signal column - as long as the Signal
column is
>> >> to the right of
>> >> >SessionID it will sort first the Session ID and then
>> >> within that for Signal.
>> >> >
>> >> >Hope this helps
>> >> >
>> >> >Cheers
>> >> >JulieD
>> >> >
>> >> >"NickH" <anonymous@discussions.microsoft.com> wrote
in
>> >> message
>> >> >news:a6e601c40a9d$551306b0$a601280a@phx.gbl...
>> >> >> Hi
>> >> >>
>> >> >> I have a small problem concerning a table/query.
>> >> >>
>> >> >> I have a table with data I wish to keep in it
>> original
>> >> >> format, however I would like to adjust in query
the
>> >> order
>> >> >> of value Ascending down, I have tried several
methods
>> >> but
>> >> >> these do not appear to resolve the problem,
Example
>> >> >>
>> >> >> This table had about 10 Fields but the first two
are
>> the
>> >> >> important ones.
>> >> >>
>> >> >> Table:Signal
>> >> >>
>> >> >> Session ID Signal
>> >> >> 1 0.165
>> >> >> 1 1.223
>> >> >> 1 9.345
>> >> >> 1 20.213
>> >> >> 2 0.189
>> >> >> 2 2.334
>> >> >> 2 19.00
>> >> >> 3 0.165
>> >> >> 3 1.223
>> >> >> 3 9.345
>> >> >> 3 20.213
>> >> >> 3 0.165
>> >> >> 3 1.223
>> >> >> 3 9.345
>> >> >> 3 20.213
>> >> >> 4 60.22
>> >> >> 4 89.872
>> >> >> 4 40.22
>> >> >> 4 10.000
>> >> >> 4 1.334
>> >> >> 4 0.1233
>> >> >> All I need to know is it possible to re-arrange
the
>> >> >> Frequency values so they Ascend for each Session
>> Block?
>> >> >> The Table above is how data is extracted so this
>> cannot
>> >> be
>> >> >> change or added too. No problems with the first
>> block,
>> >> but
>> >> >> the others!
>> >> >>
>> >> >> Thanks
>> >> >>
>> >> >>
>> >> >> Nick
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: Ascending/Descending
    ... bit confused here - if you put sort ascending on both fields with sessionid ... to the left of signal field i can't see why it's sorting so strangley, ... > I had a look and the Session ID field is to the left of ... >>Hi Nick ...
    (microsoft.public.access.queries)
  • Re: 1 in 20 UK schoolchildren thought Hitler was coach of a German football team
    ... the sort of bullshit we have had to listen to for decades. ... war even to this day. ... Euros couldn't resolve. ... liberated other occupied European nations these would have added to the ...
    (soc.culture.scottish)
  • Re: 9 months later still have error 12110
    ... The requested operation cannot be made on the FTP session ... handle because an operation is already in progress. ... Can someone tell me how to resolve this problem? ...
    (microsoft.public.frontpage.client)
  • Re: 1 in 20 UK schoolchildren thought Hitler was coach of a German football team
    ... That sort of line of yours above is just exactly the sort of thing ... war even to this day. ... Why should we be guilty? ... Euros couldn't resolve. ...
    (soc.culture.scottish)
  • Re: global.asa fires after url parameters?
    ... It fires every time I open a new browser and call my application. ... This is only an issue if a session is not established. ... The url vars are never automatically resolved. ... might resolve the url vars with request.querystring if you want. ...
    (microsoft.public.inetserver.asp.general)