Re: Ascending/Descending

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

Date: Mon, 15 Mar 2004 07:45:00 -0800

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
    ... in your query grid what is the order of the two fields - access sorts left ... > But the problem is if I select Ascending on the Session ... >>i'm assuming that you have sort ascending set on Session ...
    (microsoft.public.access.queries)
  • 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: Ascending/Descending
    ... But the problem is if I select Ascending on the Session ... and then select Ascending on the Signals field it ... >i'm assuming that you have sort ascending set on Session ...
    (microsoft.public.access.queries)
  • Re: Ascending/Descending
    ... 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. ...
    (microsoft.public.access.queries)
  • 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)
Loading