-
CR9- Report Design
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..
In the report I want in this format
CustID Mobile Land Line Office Land Line Residence
There is more if the LLOff/LLR/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
-
Re: CR9- Report Design
-
Re: CR9- Report Design
Have you tried grouping by CUSTID?