I have the Data in access like this:

custID phoneNo PhoneType
1 -----11236 ---LandLineOffice
1 ------98685 ---Mobile
2 ------98675 ---Mobile
2 ------22357 ---LandlineResi
3 ------22567 ---LandLineOffice
3 ------223554 --LandlineResi
etc.. (dotted lines dont exist)

In the report I want in this format

CustID Mobile Land Line Office Land Line Residence

There is more if the LLOff/LLRes/mob is empty no line must be left empty.
so in the above eg I should get:

CustID Mobile Land Line Office Land Line Residence
1 -----98685 --11236
2 -----98675 -----------------22357
3 -----------22567 -----------223554
dotted lines not reqd
could somebody help me find a solution