|
-
August 25th, 2008, 04:00 AM
#1
 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
Last edited by CrystalBabysteps; August 25th, 2008 at 04:09 AM.
Reporting Tool: CR9
-
April 28th, 2009, 05:21 AM
#2
Re: CR9- Report Design
Madhivanan
Failing to plan is Planning to fail
-
May 13th, 2009, 11:23 AM
#3
Re: CR9- Report Design
Have you tried grouping by CUSTID?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
