Please help- sorting and organizing data

  • Thread starter Thread starter ram8595
  • Start date Start date
R

ram8595

Ost Ocity Dstate Dcity price
A B C D 34
A B E F 45
X C L Y 78
X C M S 87
T O A B 98
Q W A B 86


Ost and Ocity go together. for example A B is the origin in first
two rows and A B is the destn in last two rows- I want to sort this
data in a report or a query such that the origin and dest are next
to one another i.e in this example the first two rows( A B as origin)
are next to last two rows( A B as destn) . The last two rows should be
3rd and 4 th row and also i want to add a summary row after the first
four rows. There are 100 s of such rows in my table. How to sort it
and summarize it

Please help thanks
 
So can you give me an example of what you want it to look like after the
sort. I didn't fully understand what you are trying to accomplish

Do you want it as

A B 34
A B 45
A B 98
A B 86

OR

A B C D 34
A B E F 45
T O A B 98
Q W A B 86

?
 
So can you give me an example of what you want it to look like after the
sort. I didn't fully understand what you are trying to accomplish

Do you want it as

A  B  34
A  B  45
A  B  98
A  B  86

OR

A  B  C  D  34
A  B  E  F  45
T  O A  B  98
Q W A  B  86

?







- Show quoted text -
Click to expand...

The second one that you mentioned- there are many records like that i
mentioned. how to get the second format that you mentioned.thanks
 
Back
Top