O!!!!!!
I just read your original post much moire carefully.
How about:

SELECT LEFT(DTOS(date),6)                     AS CurMonth,;
       IIF(FromLoc > ToLoc, FromLoc, ToLoc)   AS FromLoc,;
       IIF(FromLoc > ToLoc, ToLoc  , FromLoc) AS ToLoc,;
       COUNT(OrderID)                         AS Orders,
       AVG(Passengers)                        AS Passengers,;
       SUM(Rate)                              AS Rate;
FROM myTable
WHERE ....;
ORDER BY 1,2,3
GROUP BY 1,2,3

NOT TESTED!





>Hey Boris
>Thanks for the fast answer. In fact, i simplified the query just to ease understanding. I cannot round them, those are id's of locations. In the real select, it looks like

>select .... locs1.Name as Origin, locs2.Name as Dest .... from orders join locations locs1 on orders.FromLoc=Locations.LocationID ;
>join locations locs2 on orders.ToLoc=Locations.LocationID .....
>

>
>Jaime
>
>>>Hi all
>>>I have data similar to the following:
>>>OrderID, Date, FromLoc, ToLoc, Passengers, Rate
>>>I run the following query:

>>>select left(dtos(date),6) as CurMonth, FromLoc, ToLoc, count(OrderID) as Orders, Avg(Passengers), Sum(Rate) ;
>>>from myTable where .... order by 1,2,3 group by 1,2,3

>>>Works great, but in fact, the problem is i would like to have one row per trip, ie id like to have in the same line if i have FromLoc=x ToLoc=y or FromLoc=y and Toloc=x
>>>Any idea how to do this?
>>>TIA
>>>Jaime
>>
>>If you don't care about FromLoc and ToLoc round them with aggregate function like MAX or MIN.
>>Be careful though, you may get unexpected results :-)