Ascending/Descending

  • Thread starter Thread starter NickH
  • Start date Start date
N

NickH

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
 
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
 
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
 
Hi Nick

in your query grid what is the order of the two fields - access sorts left
to right.

Cheers
Julie
 
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
 
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
 
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
So I have tried a number of different configurations with
the above fields but still the same problem.


Thanks

Nick
 
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
 
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
 
Hi Nick

glad its solved ...

Cheers
JulieD

NickH said:
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
Click to expand...
 
Back
Top