Re: Ascending/Descending
From: JulieD (julied_ng_at_hctsReMoVeThIs.net.au)
Date: 03/15/04
- Next message: NickH: "Re: Ascending/Descending"
- Previous message: NickH: "Re: Ascending/Descending"
- In reply to: NickH: "Re: Ascending/Descending"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Mar 2004 00:17:07 +0800
Hi Nick
can't see why, if you pull out the fields that you want into the query grid,
place them left to right in the order that you want to sort them and then
sort ascending on the fields, it should work fine.
Hang on .. reading back over your posts, in some of them you say that you
want to sort by session & signal in others you say session & frequency ..
if you want session & frequency try this:
Field: SessionID Signal Frequency
Sort: Ascending (none) Ascending
if you want session & signal try this:
Field: SessionID Signal Frequency
Sort: Ascending Ascending None
Is this making sense?
Cheers
JulieD
"NickH" <anonymous@discussions.microsoft.com> wrote in message
news:d48e01c40aa7$bf5436c0$a301280a@phx.gbl...
> 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
> >>> >>
> >>> >>
> >>> >
> >>> >
> >>> >.
> >>> >
> >>
> >>
> >>.
> >>
> >.
> >
- Next message: NickH: "Re: Ascending/Descending"
- Previous message: NickH: "Re: Ascending/Descending"
- In reply to: NickH: "Re: Ascending/Descending"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
