Re: Ascending/Descending

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: 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)
  • Re: Problem with ICETOOL and symbols
    ... > I am setting up a sort that I want to use on several files. ... > The problem is that the symbol resolution pass doesn't resolve DATAREC. ... You have to define the symbol as p,m and use it for p,m in the control ...
    (bit.listserv.ibm-main)
  • Re: A simple classical problem
    ... hopefully we'll resolve. ... But those sort of personal attacks are ...
    (sci.physics.relativity)
  • Re: A simple classical problem
    ... hopefully we'll resolve. ... But those sort of personal attacks are uncalled ...
    (sci.physics.relativity)