Horizontal detail

[winsa]

Hi

Is there any way to produce the following in a report:

Group Header
Detail horizontal across the group
Count in Footer

ie. . .

Current display:
Bathurst
SR123
SR234
SR345
Total Policies: 3


Desired display:
Bathurst
SR123, SR234, SR345
Total Policies: 3


I've played around with the multicolumn settings, but can't seem to get
desired result.

Any suggestions? Thanks.

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[winsa]

Hi Duane

Thank you for that. That is what I wanted, unfortunately I'm working with
an ADP/SQL Server so Concatenate doesn't work.

Is there a TSQL alternative?!?

Regards
Winsa

 

[winsa]

I found a long winded way in SQL to do this, but it works, so thanks anyway
for your suggestion.

For anyone interested:

http://www.aspfaq.com/show.asp?id=2529

Regards
Winsa