Re: Ascending/Descending

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

Date: Mon, 15 Mar 2004 08:08:25 -0800

Julie

Something I should have mentioned, in the original Table
there is another field. and this may be the problem I am
encountering.

i.e

 Table

 Session ID Signal Freq
    5 1 0.165
    4 1 0.165
    3 1 0.165
    2 1 0.165
    9 1 1.233
    10 1 1.233
    11 1 1.233
    12 1 1.233
     7 1 1.233
     8 1 1.233
     5 2 2.678
>> And so on

So I have tried a number of different configurations with
the above fields but still the same problem.

Thanks

Nick

>-----Original Message-----
>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

  • Session times out when programaticall creating new aspx pages on the website
    ... causing this problem. ... am encountering is that the session seems to time out whenever any ... the session comes back indicating that it has timed out. ... that IIS doesn't try to recycle the current session? ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: asmx httphandler not properly protecting sessions?
    ... \par I've also done some test with your sample project and reproduced the issue you mentioned, including the issue after session has expired. ... \par Walter Wang ...
    (microsoft.public.dotnet.framework.webservices)
  • re:session_start() error
    ... It seems that the first page to start the session is fine and ... Nick ... http://eye.cc -php- web design ... Prev by Date: ...
    (comp.lang.php)
  • Session restarting for every page
    ... session object. ... The problem I am encountering is that the Session appears to ... Internet Explorer's cookie settings but even if I allow all cookies from all ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Checking latest version of the Windows Update software: No respons
    ... and cannot proceed to check for updates. ... > version installation occurred during initial session, ... > I had to recover Windows XP from manuf. ... > before encountering the problem described. ...
    (microsoft.public.windowsupdate)
Loading