Display horizontal data vertically

[HowardH]

I am putting together an index for a membership services directory for my organization. I have created a table which lists the page number(s) in which each member appear in the directory. The problem is that when I print a report based on this table the data appears horizontally:

   Member Name               PageNumber 
ABC Company                        1
ABC Company                        20
ABC Company                        187
EFGGGG Company                     1
EFGGGG Company                     98
XYZZ Company                       43
XYZZ Company                       77

I need the data to display as follows:

   MemberName            PageNumber                
ABC Company...............1,20,187
EFGGG Company.............1,98
XYZZ Company..............43,77

Any advice on how I might accomplish this (including the "...."
fill-in of varying lengths) would be greatly appreciated!

Regards,
HowardH

 

[Pat Hartman]

Try this link to an answer I posted 3 days ago.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46609&highlight=141624

 

[HowardH]

Works perfectly, Pat. Many thanks for your help!

The page numbers are now horizontally aligned and seperated by commas. What is missing now is the "....." which bridges the very end of the member name with the beginning of the first page number for that member. The # of periods will vary depending on the length of the member name. Any ideas??

 

[HowardH]

Got it!

I had to add another unbound field to the GroupFooter Section for the MemberName and added the following code:

Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
         On Local Error GoTo Detail_Format_Err
         If Not FirstPass Then
            Me!PageNum = Me![Page Number]
            Me!MemberName = Me![Member] & " " & "..........."
            FirstPass = True
            Else
            Me!PageNum = Me!PageNum & ", " & Me! _
                       [Page Number]
            Me!MemberName = Me!MemberName & " " & "..........."
Detail_Format_End:

         Exit Sub

Add as many periods as necessary to bridge the two columns then set the Can Grow property in the first column to "Yes".

Thanks again for your help!!!