Text String in Group Header

[James Frater]

Hello Everyone,

A random one for you all.

At the Group header level would there be anyway to combine one field (and
all instances of it) from the report detail as a string in a text box or
label in the group header?

So, the detail of report I have the following field [rugby] which is grouped
by [booking] and returns the results:

1
2
4
8

Which would make the string: "1,2,4,8"

Thanks

James

 

[Marshall Barton]

At the Group header level would there be anyway to combine one field (and
all instances of it) from the report detail as a string in a text box or
label in the group header?

So, the detail of report I have the following field [rugby] which is grouped
by [booking] and returns the results:

1
2
4
8

Which would make the string: "1,2,4,8"

Not directly via the report. but you can use a function to
get the list. There's a good one at:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

After you download and copy the function into your
application, you could set the text box's expression to
something like:

=Concatenate("SELECT rugby FROM yourtable WHERE Booking=" *
Me.Booking)