String multiple record fields to one text box

[Steve N via AccessMonster.com]

I am developing an Access DB for a small non-profit org secretarial uses. One
of the tables lists all member info including thier email address. For some
reason, "they" want all the members email addresses listed in a report, one
after the other, separted by commas. Example:

member1email, member2email, member3email, member4email, .... etc

Is there a way to do this in a report?

Thanks!
Steve

 

[Duane Hookom]

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

 

[Steve N via AccessMonster.com]

I can't get Access to recognize the concatenate function.
I am doing this:

eMailAddress: concatenate("SELECT EmailAddress FROM [Member List]")

Thanks!

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

I am developing an Access DB for a small non-profit org secretarial uses.
One

[quoted text clipped - 10 lines]

Thanks!
Steve

 

[Duane Hookom]

Did you create a new module with the function or import the module into your
MDB?

--
Duane Hookom
MS Access MVP

I can't get Access to recognize the concatenate function.
I am doing this:

eMailAddress: concatenate("SELECT EmailAddress FROM [Member List]")

Thanks!

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

I am developing an Access DB for a small non-profit org secretarial uses.
One

[quoted text clipped - 10 lines]

Thanks!
Steve

 

[Steve N via AccessMonster.com]

I just created a new query in my existing MDB.

Did you create a new module with the function or import the module into your
MDB?

I can't get Access to recognize the concatenate function.
I am doing this:

[quoted text clipped - 11 lines]

 

[Duane Hookom]

You need to add the Concatenate function from the sample MDB.

--
Duane Hookom
MS Access MVP

I just created a new query in my existing MDB.

Did you create a new module with the function or import the module into
your
MDB?

I can't get Access to recognize the concatenate function.
I am doing this:

[quoted text clipped - 11 lines]

Thanks!
Steve

 

[Steve N via AccessMonster.com]

I didn't see that function. It works now. Thanks!!!!

You need to add the Concatenate function from the sample MDB.

I just created a new query in my existing MDB.

[quoted text clipped - 7 lines]