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 :-)