detail string question

[Slez via AccessMonster.com]

Is there a way to include values of a control from the detail in string
format in a group's header?

As an example, if this exists in the detail section on a report:
Customer A
Customer B
Customer C
...and so on...

Can it be strung together to look like this and displayed in a group's header:

"Customer A, Customer B, Customer C, ...and so on..."

Thanks in advance for any feedback!
Slez

 

[Duane Hookom]

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

 

[Slez via AccessMonster.com]

Thanks for the info! Based on what I saw in the form, I tried the following
expression in the Control Source of a text box in a group header of a report.


=Concatenate("SELECT GCName FROM tblProjectClient WHERE ProjectID =" &
[ProjectID])

When I run the report, it first prompted me for "Concatenate", and it returns
"#Error" in the control on the report. So then I tried the following code in
the query:

Clients: Concatenate("SELECT GCName FROM tblProjectClient WHERE ProjectID ="
& [ProjectID])

I then get the error message "The specified field '[ProjectID]' could refer
to more than one table listed in the FROM clause of your SQL statement." I
tried adding ProjectID. to one, the other, and then both references to
ProjectID, only to get an error message "Undefined function 'Concatenate' in
expression."

Can you offer anty further suggestions?
Thanks again!
Slez

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

Is there a way to include values of a control from the detail in string
format in a group's header?

[quoted text clipped - 11 lines]

Thanks in advance for any feedback!
Slez