Re: Ascending/Descending

From: JulieD (julied_ng_at_hctsReMoVeThIs.net.au)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 23:52:01 +0800

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
    ... I have manged to resolve the issue. ... >bit confused here - if you put sort ascending on both ... >to the left of signal field i can't see why it's sorting ... >> I had a look and the Session ID field is to the left of ...
    (microsoft.public.access.queries)
  • Re: Kalamazoo
    ... Antiquity sessions were good. ... I missed Friday except for making an evening session ... them into the Empire. ... living, economic activity, etc. Sort of a "You're soft-selling all the ...
    (soc.history.medieval)
  • Re: Ascending/Descending
    ... can't see why, if you pull out the fields that you want into the query grid, ... sort ascending on the fields, ... want to sort by session & signal in others you say session & frequency .. ... Sort: Ascending Ascending ...
    (microsoft.public.access.queries)
  • Re: Thanks Joel for informing the FDA about LYMErix
    ... Loon...got news for you...that sort of public comment session is ... usually reserved for the appearance of public input. ...
    (sci.med.diseases.lyme)
  • Re: Where to place server code to invoke when client page closes.
    ... code the Telephony-server proxy object is already "null". ... should invoke a method of the Telephony Server. ... pass it some sort of argument? ... identifier representing the login object which I stored as a Session ...
    (microsoft.public.dotnet.framework.aspnet)