>>>BTW, in LS how did you eliminate blanks? I guess I would have to dig your utility somewhere...
>>
>>Not sure what you mean by that.
>
>If I understood your suggestion correctly you were suggesting to have
>
>select LastName, FirstName, Phone, Type from People left join Phones on People.PersonID = Phones.PerrsonID
>
>In the report we'll have
>

>Last Name First Name  Home Phone(s)       Office Phone(s)     Cellular
>LastName  FirstName   Phone (Print When Type='Home') ...

>
>My question is - how dd you get all the phones on the same line using this approach ? I believe it would not work this way and all phones would end up on a new line per phone.

Doesn't this seem like a crosstab to you?